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 7279: FROM PAY_PAYROLL_ACTIONS PPA

7275: SELECT PPA.EFFECTIVE_DATE
7276: ,PAA.ASSIGNMENT_ID
7277: INTO l_effective_date
7278: ,l_assignment_id
7279: FROM PAY_PAYROLL_ACTIONS PPA
7280: ,PAY_ASSIGNMENT_ACTIONS PAA
7281: WHERE PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
7282: AND PAA.ASSIGNMENT_ACTION_ID = P_ASSIGNMENT_ACTION_ID;
7283: EXCEPTION

Line 8008: , pay_payroll_actions PACT

8004: , pay_balance_feeds_f FEED
8005: , pay_run_results RR
8006: , pay_assignment_actions ASSACT
8007: , pay_assignment_actions BAL_ASSACT
8008: , pay_payroll_actions PACT
8009: , pay_payroll_actions BACT
8010: where BAL_ASSACT.assignment_action_id = l_assignment_action_id
8011: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
8012: and FEED.balance_type_id + 0 = l_balance_type_id + DECODE(TARGET.input_value_id

Line 8009: , pay_payroll_actions BACT

8005: , pay_run_results RR
8006: , pay_assignment_actions ASSACT
8007: , pay_assignment_actions BAL_ASSACT
8008: , pay_payroll_actions PACT
8009: , pay_payroll_actions BACT
8010: where BAL_ASSACT.assignment_action_id = l_assignment_action_id
8011: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
8012: and FEED.balance_type_id + 0 = l_balance_type_id + DECODE(TARGET.input_value_id
8013: ,null, 0, 0)