APPS.PAY_P45_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 593: FROM pay_action_interlocks pai,

589: to_date('06-04-'||to_char(fnd_number.canonical_to_number(to_char(l_eff_date,'YYYY'))),'DD-MM-YYYY')
590: and to_date('05-04-'||to_char(fnd_number.canonical_to_number(to_char(l_eff_date,'YYYY') + 1)),'DD-MM-YYYY')
591: AND NOT EXISTS(
592: SELECT '1'
593: FROM pay_action_interlocks pai,
594: pay_assignment_actions assact3,
595: pay_payroll_actions pact3
596: WHERE pai.locked_action_id = assact2.assignment_action_id
597: AND pai.locking_action_id = assact3.assignment_action_id

Line 2935: FROM pay_action_interlocks pai,

2931: to_date('06-04-'||to_char(fnd_number.canonical_to_number(to_char(l_date_earned,'YYYY'))),'DD-MM-YYYY')
2932: and to_date('05-04-'||to_char(fnd_number.canonical_to_number(to_char(l_date_earned,'YYYY') + 1)),'DD-MM-YYYY')
2933: AND NOT EXISTS(
2934: SELECT '1'
2935: FROM pay_action_interlocks pai,
2936: pay_assignment_actions assact3,
2937: pay_payroll_actions pact3
2938: WHERE pai.locked_action_id = assact2.assignment_action_id
2939: AND pai.locking_action_id = assact3.assignment_action_id

Line 3535: pay_action_interlocks pai,

3531: act.assignment_id
3532: FROM pay_payroll_actions pact,
3533: pay_assignment_actions act,
3534: per_assignments_f paf,
3535: pay_action_interlocks pai,
3536: ff_archive_items fai
3537: WHERE pact.report_type ='P45'
3538: AND pact.report_qualifier ='GB'
3539: AND pact.report_category ='P45'

Line 3576: -- FROM pay_action_interlocks pai

3572: -- FROM per_assignments_f paf2
3573: -- WHERE paf2.assignment_id = paf.assignment_id)
3574: /* commnet out this code and replace by the code below */
3575: --AND NOT EXISTS (SELECT 1
3576: -- FROM pay_action_interlocks pai
3577: -- WHERE pai.locked_action_id = act.assignment_action_id);
3578: AND pai.locked_action_id(+) = act.assignment_action_id
3579: AND decode(pai.locked_action_id,null,1,2) = 1;
3580: --

Line 3596: pay_action_interlocks pai,

3592: act.assignment_id
3593: from pay_payroll_actions pact,
3594: pay_assignment_actions act,
3595: per_assignments_f paf,
3596: pay_action_interlocks pai,
3597: pay_population_ranges ppr,
3598: ff_archive_items fai
3599: WHERE pact.report_type ='P45'
3600: AND pact.report_qualifier ='GB'

Line 3639: -- FROM pay_action_interlocks pai

3635: -- (SELECT max(paf2.effective_start_date)
3636: -- FROM per_assignments_f paf2
3637: -- WHERE paf2.assignment_id = paf.assignment_id)
3638: --AND NOT EXISTS (SELECT 1
3639: -- FROM pay_action_interlocks pai
3640: -- WHERE pai.locked_action_id = act.assignment_action_id);
3641: and pai.locked_action_id(+) = act.assignment_action_id
3642: and decode(pai.locked_action_id, null,1,2) = 1;
3643: BEGIN