Oracle DB 12.1.0.2
Hello Team,
how can I convert the functions below to SQL?
...HR_SECURITY.SHOW_PERSON (pap.person_id, pap.current_applicant_flag ,pap.current_employee_Flag, pap.current_npw_flag ,pap.employee_number, pap.applicant_number, pap.npw_number)) = 'TRUE'
HR_SECURITY.SHOW_PERSON:
FUNCTION show_person
(p_person_id IN NUMBER
,p_current_applicant_flag IN VARCHAR2
,p_current_employee_flag IN VARCHAR2
,p_current_npw_flag IN VARCHAR2
,p_employee_number IN VARCHAR2
,p_applicant_number IN VARCHAR2
,p_npw_number IN VARCHAR2)
Return VARCHAR2;
SQL:
...decode(hr_general.get_xbg_profile,'Y',pap.business_group_id , hr_general.get_business_group_id)
hr_general.get_xbg_profile:
function get_xbg_profile return varchar2;
hr_general.get_business_group_id
function GET_BUSINESS_GROUP_ID return number;
Thanks,
Roshan