eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_DI_SUBSCRIPTION_PUB dependencies on HR_GENERAL

Line 127: AND decode(hr_general.get_xbg_profile,'Y',pap.business_group_id , hr_general.get_business_group_id)

123: AND pap.person_type_id = ppt.person_type_id
124: AND ppt.system_person_type ='EMP'
125: AND decode(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE', HR_SECURITY.SHOW_RECORD('PER_ALL_PEOPLE_F', pap.person_id,
126: pap.person_type_id, pap.employee_number,pap.applicant_number)) = 'TRUE'
127: AND decode(hr_general.get_xbg_profile,'Y',pap.business_group_id , hr_general.get_business_group_id)
128: = pap.business_group_id;
129:
130: --
131: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_SUBSCRIPTION';

Line 762: AND decode(hr_general.get_xbg_profile,'Y',pap.business_group_id , hr_general.get_business_group_id)

758: AND pap.person_type_id = ppt.person_type_id
759: AND ppt.system_person_type ='EMP'
760: AND decode(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE', HR_SECURITY.SHOW_RECORD('PER_ALL_PEOPLE_F', pap.person_id,
761: pap.person_type_id, pap.employee_number,pap.applicant_number)) = 'TRUE'
762: AND decode(hr_general.get_xbg_profile,'Y',pap.business_group_id , hr_general.get_business_group_id)
763: = pap.business_group_id;
764:
765: --Used to retrieve the party id for party name and party id
766: CURSOR get_party_name_id (c_party_name IN VARCHAR2, c_party_id IN NUMBER)