APPS.PAY_INTERPRETER_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 132: -- The following cursor selects the time periods from pay_payroll_actions table.

128: l_legislation_code VARCHAR2(40);
129: l_esd DATE ;
130: l_eed DATE ;
131: --
132: -- The following cursor selects the time periods from pay_payroll_actions table.
133:
134: CURSOR c_time_period IS
135: SELECT ptp.start_date start_date,
136: ptp.end_date end_date

Line 138: pay_payroll_actions ppa,

134: CURSOR c_time_period IS
135: SELECT ptp.start_date start_date,
136: ptp.end_date end_date
137: FROM pay_assignment_actions paa,
138: pay_payroll_actions ppa,
139: per_time_periods ptp
140: WHERE paa.assignment_action_id = p_assignment_action_id
141: AND paa.payroll_action_id = ppa.payroll_action_id
142: AND nvl(ppa.date_earned,ppa.effective_date) between ptp.START_DATE and ptp.END_DATE

Line 170: pay_payroll_actions ppa,

166: CURSOR c_legislation_code IS
167: SELECT pbg.legislation_code legislation_code,
168: pbg.business_group_id business_group_id
169: FROM pay_assignment_actions paa,
170: pay_payroll_actions ppa,
171: per_business_groups_perf pbg
172: WHERE paa.assignment_action_id = p_assignment_action_id
173: AND paa.payroll_action_id = ppa.payroll_action_id
174: AND ppa.business_group_id = pbg.business_group_id ;

Line 551: pay_payroll_actions ppa

547:
548: SELECT ppa.date_earned
549: INTO l_date_earned
550: FROM pay_assignment_actions paa,
551: pay_payroll_actions ppa
552: WHERE paa.assignment_action_id = p_assignment_action_id
553: AND paa.payroll_action_id = ppa.payroll_action_id ;
554:
555: -- The following statement selects the Proration Group Id

Line 1345: from pay_payroll_actions ppa,

1341: select ''
1342: into l_dummy
1343: from dual
1344: where exists (select ''
1345: from pay_payroll_actions ppa,
1346: pay_assignment_actions paa
1347: where paa.assignment_id = p_assignment_id
1348: and ppa.payroll_action_id = paa.payroll_action_id
1349: and ppa.action_type in ('R', 'Q', 'B', 'V')

Line 2031: pay_payroll_actions ppa,

2027: is
2028: select ptp_td.start_date
2029: from per_time_periods ptp_td,
2030: pay_assignment_actions paa,
2031: pay_payroll_actions ppa,
2032: per_time_periods ptp_ppa
2033: where ptp_td.time_definition_id = p_time_def
2034: and paa.assignment_action_id = p_asg_act
2035: and paa.payroll_action_id = ppa.payroll_action_id