DBA Data[Home] [Help]

APPS.PAY_PYAURECP_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 295: C_TAX_UNIT_ID IN HR_ALL_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE,

291: AND HR.LOOKUP_TYPE = 'AU_PS_FINANCIAL_YEAR';
292:
293: CURSOR GET_MAX_ACTION
294: (C_ASSIGNMENT_ID IN PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE,
295: C_TAX_UNIT_ID IN HR_ALL_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE,
296: C_YEAR_START IN DATE,
297: C_YEAR_END IN DATE )
298: IS
299: SELECT TO_NUMBER(SUBSTR(MAX(LPAD(PAA.ACTION_SEQUENCE,15,'0')||PAA.ASSIGNMENT_ACTION_ID),16)) ASSIGNMENT_ACTION_ID