DBA Data[Home] [Help]

APPS.PAY_NO_ABSENCE dependencies on PAY_PAYROLL_ACTIONS

Line 140: ,PAY_PAYROLL_ACTIONS PPA

136:
137: CURSOR CSR_CUR_ABS_PRORATED (P_ASSIGNMENT_ID NUMBER, P_EFFECTIVE_DATE DATE, P_ST_DT DATE, P_EN_DT DATE) IS
138: SELECT DATE_EARNED
139: FROM PER_ALL_ASSIGNMENTS_F PAA
140: ,PAY_PAYROLL_ACTIONS PPA
141: ,PAY_ASSIGNMENT_ACTIONS PASG
142: WHERE PAA.PAYROLL_ID = PPA.PAYROLL_ID
143: AND PAA.ASSIGNMENT_ID = P_ASSIGNMENT_ID
144: AND PAA.ASSIGNMENT_ID = PASG.ASSIGNMENT_ID

Line 7179: FROM PAY_PAYROLL_ACTIONS PPA

7175: SELECT PPA.EFFECTIVE_DATE
7176: ,PAA.ASSIGNMENT_ID
7177: INTO l_effective_date
7178: ,l_assignment_id
7179: FROM PAY_PAYROLL_ACTIONS PPA
7180: ,PAY_ASSIGNMENT_ACTIONS PAA
7181: WHERE PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
7182: AND PAA.ASSIGNMENT_ACTION_ID = P_ASSIGNMENT_ACTION_ID;
7183: EXCEPTION