APPS.PAY_NO_ARC_RSEA_07 dependencies on PAY_ASSIGNMENT_ACTIONS

Line 444: ,pay_assignment_actions act

440: SELECT DISTINCT act.assignment_id assignment_id
441: FROM pay_payroll_actions ppa
442: ,pay_payroll_actions appa
443: ,pay_payroll_actions appa2
444: ,pay_assignment_actions act
445: ,pay_assignment_actions act1
446: ,pay_action_interlocks pai
447: ,per_all_assignments_f as1
448: ,hr_soft_coding_keyflex hsck

Line 445: ,pay_assignment_actions act1

441: FROM pay_payroll_actions ppa
442: ,pay_payroll_actions appa
443: ,pay_payroll_actions appa2
444: ,pay_assignment_actions act
445: ,pay_assignment_actions act1
446: ,pay_action_interlocks pai
447: ,per_all_assignments_f as1
448: ,hr_soft_coding_keyflex hsck
449: WHERE ppa.payroll_action_id = p_payroll_action_id

Line 498: ,pay_assignment_actions act

494: SELECT DISTINCT act.assignment_id assignment_id
495: FROM pay_payroll_actions ppa
496: ,pay_payroll_actions appa
497: ,pay_payroll_actions appa2
498: ,pay_assignment_actions act
499: ,pay_assignment_actions act1
500: ,pay_action_interlocks pai
501: ,per_all_assignments_f as1
502: ,hr_soft_coding_keyflex hsck

Line 499: ,pay_assignment_actions act1

495: FROM pay_payroll_actions ppa
496: ,pay_payroll_actions appa
497: ,pay_payroll_actions appa2
498: ,pay_assignment_actions act
499: ,pay_assignment_actions act1
500: ,pay_action_interlocks pai
501: ,per_all_assignments_f as1
502: ,hr_soft_coding_keyflex hsck
503: WHERE ppa.payroll_action_id = p_payroll_action_id

Line 532: FROM pay_assignment_actions paa,

528: l_end_date DATE,
529: p_local_unit_id NUMBER,
530: p_legal_employer_id NUMBER) IS
531: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) asg_action_id
532: FROM pay_assignment_actions paa,
533: pay_payroll_actions ppa,
534: per_all_assignments_f paaf,
535: hr_soft_coding_keyflex hsck
536: WHERE ppa.payroll_action_id = paa.payroll_action_id