APPS.PAY_P45_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 650: FROM pay_action_interlocks pai,

646: to_date('06-04-'||to_char(fnd_number.canonical_to_number(to_char(l_eff_date,'YYYY'))),'DD-MM-YYYY')
647: and to_date('05-04-'||to_char(fnd_number.canonical_to_number(to_char(l_eff_date,'YYYY') + 1)),'DD-MM-YYYY')
648: AND NOT EXISTS(
649: SELECT '1'
650: FROM pay_action_interlocks pai,
651: pay_assignment_actions assact3,
652: pay_payroll_actions pact3
653: WHERE pai.locked_action_id = assact2.assignment_action_id
654: AND pai.locking_action_id = assact3.assignment_action_id

Line 3320: FROM pay_action_interlocks pai,

3316: to_date('06-04-'||to_char(fnd_number.canonical_to_number(to_char(l_date_earned,'YYYY'))),'DD-MM-YYYY')
3317: and to_date('05-04-'||to_char(fnd_number.canonical_to_number(to_char(l_date_earned,'YYYY') + 1)),'DD-MM-YYYY')
3318: AND NOT EXISTS(
3319: SELECT '1'
3320: FROM pay_action_interlocks pai,
3321: pay_assignment_actions assact3,
3322: pay_payroll_actions pact3
3323: WHERE pai.locked_action_id = assact2.assignment_action_id
3324: AND pai.locking_action_id = assact3.assignment_action_id

Line 4317: pay_action_interlocks pai,

4313: act.assignment_id
4314: FROM pay_payroll_actions pact,
4315: pay_assignment_actions act,
4316: per_assignments_f paf,
4317: pay_action_interlocks pai,
4318: ff_archive_items fai
4319: WHERE pact.report_type ='P45'
4320: AND pact.report_qualifier ='GB'
4321: AND pact.report_category ='P45'

Line 4358: -- FROM pay_action_interlocks pai

4354: -- FROM per_assignments_f paf2
4355: -- WHERE paf2.assignment_id = paf.assignment_id)
4356: /* commnet out this code and replace by the code below */
4357: --AND NOT EXISTS (SELECT 1
4358: -- FROM pay_action_interlocks pai
4359: -- WHERE pai.locked_action_id = act.assignment_action_id);
4360: AND pai.locked_action_id(+) = act.assignment_action_id
4361: AND decode(pai.locked_action_id,null,1,2) = 1;
4362: --

Line 4422: FROM pay_action_interlocks pai

4418: -- (SELECT max(paf2.effective_start_date)
4419: -- FROM per_assignments_f paf2
4420: -- WHERE paf2.assignment_id = paf.assignment_id)
4421: AND NOT EXISTS (SELECT 1
4422: FROM pay_action_interlocks pai
4423: WHERE pai.locked_action_id = act.assignment_action_id);
4424:
4425: BEGIN
4426: hr_utility.set_location('Entering: '||l_proc,1);