APPS.PAY_FR_DUCS dependencies on PAY_ACTION_INTERLOCKS

Line 365: FROM pay_action_interlocks plock

361: AND cmp_check.org_information1 = p_company_id_chr;
362: --
363: CURSOR csr_locking_archive(p_run_act_id number) is
364: SELECT /*+ ORDERED */ 1
365: FROM pay_action_interlocks plock
366: , pay_assignment_actions assact
367: , pay_action_information actinfo
368: WHERE plock.locked_action_id = p_run_act_id
369: AND plock.locking_action_id = assact.assignment_action_id

Line 516: FROM pay_action_interlocks interlock

512: CURSOR csr_locked_action_info is
513: SELECT payact.action_type type,
514: locked_assact.assignment_action_id id,
515: locked_assact.tax_unit_id
516: FROM pay_action_interlocks interlock
517: , pay_assignment_actions locked_assact
518: , pay_payroll_actions payact
519: WHERE interlock.locking_action_id = p_assignment_action_id
520: AND interlock.locked_action_id = locked_assact.assignment_action_id

Line 525: FROM pay_action_interlocks rev_interlock

521: AND locked_assact.payroll_action_id = payact.payroll_action_id;
522: --
523: CURSOR csr_locking_reversal (p_run_act_id number) is
524: SELECT 1 /* if the run action is reversed exclude it */
525: FROM pay_action_interlocks rev_interlock
526: , pay_assignment_actions rev_assact
527: , pay_payroll_actions rev_payact
528: WHERE rev_interlock.locked_action_id = p_run_act_id
529: AND rev_interlock.locking_action_id = rev_assact.assignment_action_id

Line 543: ,pay_action_interlocks interlock

539: ,runchild.assignment_id
540: ,runchild.tax_unit_id
541: ,pay_assignment_actions_s.nextval new_ass_act_id
542: FROM pay_assignment_actions assact
543: ,pay_action_interlocks interlock
544: ,pay_assignment_actions runchild
545: WHERE assact.assignment_action_id = p_assignment_action_id
546: AND interlock.locking_action_id = assact.assignment_action_id
547: AND interlock.locked_action_id = runchild.source_action_id;

Line 717: FROM pay_action_interlocks ail,

713: g_english_pay_value, decode(ec.classification_name,'Rebates',-1,1) *
714: fnd_number.canonical_to_number(rrv.result_value),
715: g_french_pay_value, decode(ec.classification_name,'Rebates',-1,1) *
716: fnd_number.canonical_to_number(rrv.result_value))),0) pv
717: FROM pay_action_interlocks ail,
718: pay_run_results rr,
719: pay_element_types_f et,
720: pay_element_classifications ec,
721: pay_input_values_f iv,