APPS.PAY_MX_ANNUAL_WRI dependencies on PAY_ACTION_INTERLOCKS

Line 214: pay_action_interlocks lck,

210: paf.effective_end_date
211: FROM per_assignments_f paf,
212: pay_payroll_actions ppa_sua,
213: pay_assignment_actions paa_sua,
214: pay_action_interlocks lck,
215: pay_action_information pai
216: WHERE ppa_sua.payroll_action_id = paa_sua.payroll_action_id
217: AND paa_sua.assignment_id = paf.assignment_id
218: AND paa_sua.assignment_action_id = lck.locking_action_id

Line 257: pay_action_interlocks lck,

253: paf.effective_end_date
254: FROM per_assignments_f paf,
255: pay_payroll_actions ppa_sua,
256: pay_assignment_actions paa_sua,
257: pay_action_interlocks lck,
258: pay_action_information pai,
259: pay_population_ranges ppr
260: WHERE ppa_sua.payroll_action_id = paa_sua.payroll_action_id
261: AND paa_sua.assignment_id = paf.assignment_id

Line 425: pay_action_interlocks lck_sua,

421: CURSOR csr_transactions (cp_wri_asg_act number) IS
422: SELECT pai.action_information_id,
423: nvl(pai.action_information10, 'N') -- Do not report flag
424: FROM pay_action_information pai,
425: pay_action_interlocks lck_sua,
426: pay_action_interlocks lck_arch
427: WHERE lck_sua.locking_action_id = cp_wri_asg_act
428: AND lck_sua.locked_action_id = lck_arch.locking_action_id
429: AND lck_arch.locked_action_id = pai.action_context_id

Line 426: pay_action_interlocks lck_arch

422: SELECT pai.action_information_id,
423: nvl(pai.action_information10, 'N') -- Do not report flag
424: FROM pay_action_information pai,
425: pay_action_interlocks lck_sua,
426: pay_action_interlocks lck_arch
427: WHERE lck_sua.locking_action_id = cp_wri_asg_act
428: AND lck_sua.locked_action_id = lck_arch.locking_action_id
429: AND lck_arch.locked_action_id = pai.action_context_id
430: AND pai.action_information_category = 'MX SS TRANSACTIONS'

Line 446: pay_action_interlocks lck,

442: SELECT pai.action_information_id
443: FROM pay_action_information pai,
444: pay_assignment_actions paa,
445: pay_payroll_actions ppa,
446: pay_action_interlocks lck,
447: pay_assignment_actions paa_arch,
448: pay_payroll_actions ppa_arch
449: WHERE paa.payroll_action_id = ppa.payroll_action_id
450: AND fnd_number.canonical_to_number(

Line 479: pay_action_interlocks lck_sua,

475: pay_mx_utility.get_legi_param_val('END_DATE',
476: ppa.legislative_parameters)) DESC;
477: /*SELECT pai.action_information_id
478: FROM pay_action_information pai,
479: pay_action_interlocks lck_sua,
480: pay_action_interlocks lck_arch,
481: pay_payroll_actions ppa_arch,
482: pay_assignment_actions paa_arch
483: WHERE lck_sua.locking_action_id = cp_wri_asg_act

Line 480: pay_action_interlocks lck_arch,

476: ppa.legislative_parameters)) DESC;
477: /*SELECT pai.action_information_id
478: FROM pay_action_information pai,
479: pay_action_interlocks lck_sua,
480: pay_action_interlocks lck_arch,
481: pay_payroll_actions ppa_arch,
482: pay_assignment_actions paa_arch
483: WHERE lck_sua.locking_action_id = cp_wri_asg_act
484: AND lck_sua.locked_action_id = lck_arch.locking_action_id

Line 599: pay_action_interlocks lck_sua,

595:
596: CURSOR csr_employer IS
597: SELECT pai.action_information_id
598: FROM pay_action_information pai,
599: pay_action_interlocks lck_sua,
600: pay_action_interlocks lck_arch,
601: pay_assignment_actions paa_arch,
602: pay_assignment_actions paa_wri
603: WHERE paa_wri.payroll_action_id =

Line 600: pay_action_interlocks lck_arch,

596: CURSOR csr_employer IS
597: SELECT pai.action_information_id
598: FROM pay_action_information pai,
599: pay_action_interlocks lck_sua,
600: pay_action_interlocks lck_arch,
601: pay_assignment_actions paa_arch,
602: pay_assignment_actions paa_wri
603: WHERE paa_wri.payroll_action_id =
604: pay_magtape_generic.get_parameter_value ('PAYROLL_ACTION_ID')