APPS.PAY_IN_FF_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 196: pay_assignment_actions paa,

192: /* This cursor returns the latest of first pay period date and contribution period start date */
193: CURSOR get_date(l_start date) IS
194: SELECT GREATEST( MIN(ppa.date_earned),l_start)
195: FROM pay_payroll_actions ppa,
196: pay_assignment_actions paa,
197: per_all_assignments_f paf
198: WHERE paf.assignment_id =p_assignment_id
199: AND paf.assignment_id=paa.assignment_id
200: AND paa.payroll_action_id =ppa.payroll_action_id;

Line 206: ,pay_assignment_actions paa

202: -- Cursor for Max Assignment Action ID for the contribution period
203: CURSOR csr_casact (l_virtual_date IN DATE) IS
204: SELECT paa.assignment_action_id
205: FROM pay_payroll_actions ppa
206: ,pay_assignment_actions paa
207: WHERE paa.payroll_action_id = ppa.payroll_action_id
208: AND paa.assignment_id = p_assignment_id
209: AND last_day(ppa.date_earned) = l_virtual_date
210: AND paa.source_action_id IS NULL

Line 376: pay_assignment_actions paa,

372: /* This cursor returns the latest of first pay period date and contribution period start date */
373: CURSOR get_date(l_start date) IS
374: SELECT GREATEST( MIN(ppa.date_earned),l_start)
375: FROM pay_payroll_actions ppa,
376: pay_assignment_actions paa,
377: per_all_assignments_f paf
378: WHERE paf.assignment_id =p_assignment_id
379: AND paf.assignment_id=paa.assignment_id
380: AND paa.payroll_action_id =ppa.payroll_action_id;

Line 979: ,pay_assignment_actions paa

975: CURSOR c_max_pay_date
976: IS
977: SELECT ppa.date_earned
978: FROM pay_payroll_actions ppa
979: ,pay_assignment_actions paa
980: WHERE ppa.payroll_action_id = paa.payroll_action_id
981: AND ppa.action_type IN ('Q','R')
982: AND ppa.action_status = 'C'
983: AND paa.source_action_id IS NULL