APPS.PAY_PYAURECP_XMLP_PKG dependencies on HR_LOOKUPS

Line 42: CURSOR C_HL_MEANING(C_HL_CODE IN HR_LOOKUPS.LOOKUP_CODE%TYPE) IS

38: MAX(PPF1.EFFECTIVE_START_DATE)
39: FROM
40: PAY_PAYROLLS_F PPF1
41: WHERE PPF1.PAYROLL_ID = PPF.PAYROLL_ID );
42: CURSOR C_HL_MEANING(C_HL_CODE IN HR_LOOKUPS.LOOKUP_CODE%TYPE) IS
43: SELECT
44: HL.MEANING
45: FROM
46: HR_LOOKUPS HL

Line 46: HR_LOOKUPS HL

42: CURSOR C_HL_MEANING(C_HL_CODE IN HR_LOOKUPS.LOOKUP_CODE%TYPE) IS
43: SELECT
44: HL.MEANING
45: FROM
46: HR_LOOKUPS HL
47: WHERE HL.LOOKUP_TYPE = 'AU_PS_EMPLOYEE_TYPE'
48: AND HL.ENABLED_FLAG = 'Y'
49: AND HL.LOOKUP_CODE = C_HL_CODE;
50: CURSOR C_ASSIGNMENT_INFO(C_ASSIGNMENT_ID IN NUMBER) IS

Line 266: HR_LOOKUPS HR

262: SELECT
263: HR.MEANING FIN_YEAR
264: FROM
265: PER_ASSIGNMENT_EXTRA_INFO PAE,
266: HR_LOOKUPS HR
267: WHERE PAE.AEI_INFORMATION_CATEGORY = 'HR_PS_ISSUE_DATE_AU'
268: AND PAE.INFORMATION_TYPE = 'HR_PS_ISSUE_DATE_AU'
269: AND PAE.ASSIGNMENT_ID = C_ASSIGNMENT_ID
270: AND PAE.AEI_INFORMATION1 = TO_CHAR(C_FIN_DATE