APPS.PAY_CA_RL1_CAN_MAG dependencies on PAY_ACTION_INTERLOCKS

Line 468: pay_action_interlocks int

464: pay_payroll_actions ppa1,
465: pay_payroll_actions ppa2,
466: pay_assignment_actions paa,
467: pay_assignment_actions paa1,
468: pay_action_interlocks int
469: where
470: ppa.payroll_action_id = paa.payroll_action_id
471: and paa.assignment_id = paaf.assignment_id
472: and ppa1.payroll_action_id = p_pactid

Line 483: from pay_action_interlocks pai, pay_assignment_actions paa2

479: and ppa2.payroll_action_id = paa1.payroll_action_id
480: and ppa2.action_status = 'C'
481: and paa.assignment_action_id
482: not in (select paa2.assignment_action_id
483: from pay_action_interlocks pai, pay_assignment_actions paa2
484: where paa2.assignment_action_id = pai.locked_action_id
485: and paa2.payroll_action_id =
486: to_number(pay_ca_rl1_can_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))
487: )

Line 509: pay_action_interlocks int

505: pay_payroll_actions ppa1,
506: pay_payroll_actions ppa2,
507: pay_assignment_actions paa,
508: pay_assignment_actions paa1,
509: pay_action_interlocks int
510: where
511: ppa.payroll_action_id = paa.payroll_action_id
512: and paa.assignment_id = paaf.assignment_id
513: and ppa1.payroll_action_id = p_pactid

Line 531: from pay_action_interlocks pai, pay_assignment_actions paa2

527: and hasa.assignment_id = paf.assignment_id
528: and paf.person_id = paaf.person_id)
529: and paa.assignment_action_id
530: not in (select paa2.assignment_action_id
531: from pay_action_interlocks pai, pay_assignment_actions paa2
532: where paa2.assignment_action_id = pai.locked_action_id
533: and paa2.payroll_action_id =
534: to_number(pay_ca_rl1_can_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))
535: )

Line 911: pay_action_interlocks int

907: select max(paa1.payroll_action_id)
908: into l_context1
909: from pay_assignment_actions paa,
910: pay_assignment_actions paa1,
911: pay_action_interlocks int
912: where int.locking_action_id = paa.assignment_action_id
913: AND paa1.assignment_action_id = int.locked_action_id
914: and paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
915:

Line 1353: pay_action_interlocks pai_mag,

1349: ff_archive_items fai,
1350: ff_database_items fdi,
1351: per_all_people_f ppf,
1352: per_all_assignments_f paf,
1353: pay_action_interlocks pai_mag,
1354: pay_action_interlocks pai_arch,
1355: pay_payroll_actions ppa,
1356: pay_payroll_actions ppa_arch,
1357: pay_assignment_actions paa_mag,

Line 1354: pay_action_interlocks pai_arch,

1350: ff_database_items fdi,
1351: per_all_people_f ppf,
1352: per_all_assignments_f paf,
1353: pay_action_interlocks pai_mag,
1354: pay_action_interlocks pai_arch,
1355: pay_payroll_actions ppa,
1356: pay_payroll_actions ppa_arch,
1357: pay_assignment_actions paa_mag,
1358: pay_assignment_actions paa_arch

Line 3119: pay_action_interlocks int

3115: select max(paa1.payroll_action_id)
3116: into l_context1
3117: from pay_assignment_actions paa,
3118: pay_assignment_actions paa1,
3119: pay_action_interlocks int
3120: where int.locking_action_id = paa.assignment_action_id
3121: AND paa1.assignment_action_id = int.locked_action_id
3122: and paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
3123: