APPS.PAY_PAYAUSOE_XMLP_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 21: LV_DATE_EARNED PAY_PAYROLL_ACTIONS.DATE_EARNED%TYPE;

17: FUNCTION CF_CURRENCY_FORMAT_MASKFORMULA RETURN VARCHAR2 IS
18: V_CURRENCY_CODE FND_CURRENCIES.CURRENCY_CODE%TYPE;
19: V_FORMAT_MASK VARCHAR2(100) := NULL;
20: V_FIELD_LENGTH NUMBER(3) := 15;
21: LV_DATE_EARNED PAY_PAYROLL_ACTIONS.DATE_EARNED%TYPE;
22: CURSOR C_DATE_EARNED(PAYROLL_ACT_ID IN PAY_PAYROLL_ACTIONS.PAYROLL_ACTION_ID%TYPE) IS
23: SELECT
24: EFFECTIVE_DATE
25: FROM

Line 22: CURSOR C_DATE_EARNED(PAYROLL_ACT_ID IN PAY_PAYROLL_ACTIONS.PAYROLL_ACTION_ID%TYPE) IS

18: V_CURRENCY_CODE FND_CURRENCIES.CURRENCY_CODE%TYPE;
19: V_FORMAT_MASK VARCHAR2(100) := NULL;
20: V_FIELD_LENGTH NUMBER(3) := 15;
21: LV_DATE_EARNED PAY_PAYROLL_ACTIONS.DATE_EARNED%TYPE;
22: CURSOR C_DATE_EARNED(PAYROLL_ACT_ID IN PAY_PAYROLL_ACTIONS.PAYROLL_ACTION_ID%TYPE) IS
23: SELECT
24: EFFECTIVE_DATE
25: FROM
26: PAY_PAYROLL_ACTIONS

Line 26: PAY_PAYROLL_ACTIONS

22: CURSOR C_DATE_EARNED(PAYROLL_ACT_ID IN PAY_PAYROLL_ACTIONS.PAYROLL_ACTION_ID%TYPE) IS
23: SELECT
24: EFFECTIVE_DATE
25: FROM
26: PAY_PAYROLL_ACTIONS
27: WHERE PAYROLL_ACTION_ID = PAYROLL_ACT_ID;
28: BEGIN
29: OPEN C_DATE_EARNED(P_PAYROLL_ACTION_ID);
30: FETCH C_DATE_EARNED

Line 59: PAY_PAYROLL_ACTIONS PA,

55: PAY_ELEMENT_TYPES_F ET,
56: PAY_ELEMENT_LINKS_F EL,
57: PAY_ELEMENT_ENTRIES_F EE,
58: PAY_ASSIGNMENT_ACTIONS AA,
59: PAY_PAYROLL_ACTIONS PA,
60: PER_ABSENCE_ATTENDANCE_TYPES PAAT,
61: PER_TIME_PERIODS TP
62: WHERE AA.ASSIGNMENT_ACTION_ID = R_ASG_ASSIGNMENT_ACTION_ID
63: AND AP.ACCRUAL_CATEGORY = 'AUAL'

Line 301: PAY_PAYROLL_ACTIONS PPA,

297: SELECT
298: PTP.START_DATE
299: FROM
300: PAY_ASSIGNMENT_ACTIONS PAC,
301: PAY_PAYROLL_ACTIONS PPA,
302: PER_TIME_PERIODS PTP
303: WHERE PPA.PAYROLL_ACTION_ID = PAC.PAYROLL_ACTION_ID
304: AND PAC.SOURCE_ACTION_ID is null
305: AND PTP.PAYROLL_ID = PPA.PAYROLL_ID