DBA Data[Home] [Help]

APPS.PAY_GB_MULTI_PAYROLL_RUN dependencies on PER_TIME_PERIODS

Line 54: FROM PER_TIME_PERIODS PTP

50: BEGIN
51:
52: SELECT PTP.TIME_PERIOD_ID INTO
53: V_TIME_PERIOD_ID
54: FROM PER_TIME_PERIODS PTP
55: WHERE PTP.PERIOD_NAME=P_TIME_PERIOD_NAME
56: AND PTP.PAYROLL_ID=P_PAYROLL_ID;
57:
58: RETURN V_TIME_PERIOD_ID;

Line 461: ,PER_TIME_PERIODS PTP

457: PAY_PRE_PAYMENTS PPP
458: ,PAY_ASSIGNMENT_ACTIONS PAA
459: ,PER_ALL_ASSIGNMENTS_F PAAF
460: ,PAY_ORG_PAYMENT_METHODS_F POPMF
461: ,PER_TIME_PERIODS PTP
462: WHERE PPP.ASSIGNMENT_ACTION_ID=PAA.ASSIGNMENT_ACTION_ID
463: AND PAA.ASSIGNMENT_ID=PAAF.ASSIGNMENT_ID
464: AND PAAF.PAYROLL_ID=PTP.PAYROLL_ID
465: AND PAAF.PAYROLL_ID=P_PAYROLL_ID