APPS.PAY_IN_FF_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 194: pay_assignment_actions paa,

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

Line 204: ,pay_assignment_actions paa

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

Line 370: pay_assignment_actions paa,

366: /* This cursor returns the latest of first pay period date and contribution period start date */
367: CURSOR get_date(l_start date) IS
368: SELECT GREATEST( MIN(ppa.date_earned),l_start)
369: FROM pay_payroll_actions ppa,
370: pay_assignment_actions paa,
371: per_all_assignments_f paf
372: WHERE paf.assignment_id =p_assignment_id
373: AND paf.assignment_id=paa.assignment_id
374: AND paa.payroll_action_id =ppa.payroll_action_id;

Line 973: ,pay_assignment_actions paa

969: CURSOR c_max_pay_date
970: IS
971: SELECT ppa.date_earned
972: FROM pay_payroll_actions ppa
973: ,pay_assignment_actions paa
974: WHERE ppa.payroll_action_id = paa.payroll_action_id
975: AND ppa.action_type IN ('Q','R')
976: AND ppa.action_status = 'C'
977: AND paa.source_action_id IS NULL