APPS.PAY_FR_ARC_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 521: ,pay_action_interlocks lok

517: ,master_arc.chunk_number chunk_number
518: ,master_arc.payroll_action_id payroll_action_id
519: ,pay_assignment_actions_s.nextval new_ass_act_id
520: FROM pay_assignment_Actions master_arc
521: ,pay_action_interlocks lok
522: ,pay_assignment_Actions child_pre
523: WHERE master_arc.assignment_action_id = p_assactid
524: and lok.locking_Action_id = master_arc.assignment_action_id
525: and lok.locked_action_id = child_pre.source_action_id;

Line 1267: FROM pay_action_interlocks arc_interlock

1263: cursor csr_date_earned(p_establishment_id number
1264: ,p_archive_action_id number) is
1265: SELECT run_payact.effective_date, run_assact.action_sequence,
1266: run_assact.assignment_action_id, proc_type.context_value
1267: FROM pay_action_interlocks arc_interlock
1268: , pay_action_interlocks pre_interlock
1269: , pay_assignment_actions run_assact
1270: , pay_payroll_actions run_payact
1271: , pay_action_contexts proc_type /*will exclude proration actions*/

Line 1268: , pay_action_interlocks pre_interlock

1264: ,p_archive_action_id number) is
1265: SELECT run_payact.effective_date, run_assact.action_sequence,
1266: run_assact.assignment_action_id, proc_type.context_value
1267: FROM pay_action_interlocks arc_interlock
1268: , pay_action_interlocks pre_interlock
1269: , pay_assignment_actions run_assact
1270: , pay_payroll_actions run_payact
1271: , pay_action_contexts proc_type /*will exclude proration actions*/
1272: WHERE arc_interlock.locking_action_id = p_archive_action_id

Line 1286: FROM pay_action_interlocks rev_interlock

1282: ,run_assact.action_sequence desc ;
1283: --
1284: CURSOR csr_locking_reversal (p_run_act_id number) is
1285: SELECT 1 /* if the run action is reversed exclude it */
1286: FROM pay_action_interlocks rev_interlock
1287: , pay_assignment_actions rev_assact
1288: , pay_payroll_actions rev_payact
1289: WHERE rev_interlock.locked_action_id = p_run_act_id
1290: AND rev_interlock.locking_action_id = rev_assact.assignment_action_id

Line 1427: from pay_action_interlocks a_lock

1423: cursor csr_actual_deposit_date (p_payroll_id number
1424: ,p_assignment_action_id number
1425: ,p_assignment_id number) is
1426: select m_ppa.overriding_dd_date
1427: from pay_action_interlocks a_lock
1428: ,pay_payroll_actions a_ppa
1429: ,pay_assignment_Actions a_asg
1430: ,pay_assignment_actions m_asg
1431: ,pay_assignment_actions p_asg

Line 1433: ,pay_action_interlocks m_lock

1429: ,pay_assignment_Actions a_asg
1430: ,pay_assignment_actions m_asg
1431: ,pay_assignment_actions p_asg
1432: ,pay_payroll_actions m_ppa
1433: ,pay_action_interlocks m_lock
1434: where a_lock.locking_Action_id = p_assignment_action_id
1435: and a_lock.locked_action_id = a_asg.assignment_Action_id
1436: and a_asg.payroll_action_id = a_ppa.payroll_action_id
1437: and a_asg.assignment_id = p_assignment_id

Line 2108: from pay_action_interlocks this_arc_lock

2104: ,ppp.value amount
2105: ,count(decode(all_arc_lock.locking_action_id
2106: ,this_arc_lock.locking_action_id,null
2107: ,all_arc_lock.locking_action_id)) num_previous
2108: from pay_action_interlocks this_arc_lock
2109: ,pay_action_interlocks all_arc_lock
2110: ,pay_assignment_actions arc_assact
2111: ,pay_payroll_actions arc_payact
2112: ,pay_pre_payments ppp

Line 2109: ,pay_action_interlocks all_arc_lock

2105: ,count(decode(all_arc_lock.locking_action_id
2106: ,this_arc_lock.locking_action_id,null
2107: ,all_arc_lock.locking_action_id)) num_previous
2108: from pay_action_interlocks this_arc_lock
2109: ,pay_action_interlocks all_arc_lock
2110: ,pay_assignment_actions arc_assact
2111: ,pay_payroll_actions arc_payact
2112: ,pay_pre_payments ppp
2113: ,pay_personal_payment_methods_f pppmf

Line 2232: ,pay_action_interlocks arc_lock

2228: from pay_payroll_actions pre_payact
2229: ,pay_assignment_actions pre_assact
2230: ,pay_payroll_actions run_payact
2231: ,pay_assignment_actions run_assact
2232: ,pay_action_interlocks arc_lock
2233: ,pay_action_interlocks pre_lock
2234: where
2235: arc_lock.locking_action_id = p_archive_assignment_action_id
2236: and arc_lock.locked_action_id = pre_assact.assignment_action_id

Line 2233: ,pay_action_interlocks pre_lock

2229: ,pay_assignment_actions pre_assact
2230: ,pay_payroll_actions run_payact
2231: ,pay_assignment_actions run_assact
2232: ,pay_action_interlocks arc_lock
2233: ,pay_action_interlocks pre_lock
2234: where
2235: arc_lock.locking_action_id = p_archive_assignment_action_id
2236: and arc_lock.locked_action_id = pre_assact.assignment_action_id
2237: and pre_lock.locking_action_id = pre_assact.assignment_action_id

Line 2413: ,pay_action_interlocks arc_lock

2409: ,pay_payroll_actions pre_payact
2410: ,pay_assignment_actions pre_assact
2411: ,pay_payroll_actions run_payact
2412: ,pay_assignment_actions run_assact
2413: ,pay_action_interlocks arc_lock
2414: ,pay_action_interlocks pre_lock
2415: ,pay_element_entries_f pee
2416: ,pay_run_results rr_ret
2417: where pee.element_entry_id(+) = prr.source_id

Line 2414: ,pay_action_interlocks pre_lock

2410: ,pay_assignment_actions pre_assact
2411: ,pay_payroll_actions run_payact
2412: ,pay_assignment_actions run_assact
2413: ,pay_action_interlocks arc_lock
2414: ,pay_action_interlocks pre_lock
2415: ,pay_element_entries_f pee
2416: ,pay_run_results rr_ret
2417: where pee.element_entry_id(+) = prr.source_id
2418: and rr_ret.run_result_id(+) = pee.source_id

Line 3028: ,pay_action_interlocks arc_lock

3024: ,pay_run_result_values prrv
3025: ,fnd_lookup_values user_rubric
3026: ,fnd_lookup_values seed_rubric
3027: ,fnd_lookup_values base_units
3028: ,pay_action_interlocks arc_lock
3029: ,pay_action_interlocks pre_lock
3030: ,pay_assignment_actions run_assact
3031: ,pay_payroll_actions run_payact
3032: where pet.classification_id in (p_ee_classification, p_er_classification)

Line 3029: ,pay_action_interlocks pre_lock

3025: ,fnd_lookup_values user_rubric
3026: ,fnd_lookup_values seed_rubric
3027: ,fnd_lookup_values base_units
3028: ,pay_action_interlocks arc_lock
3029: ,pay_action_interlocks pre_lock
3030: ,pay_assignment_actions run_assact
3031: ,pay_payroll_actions run_payact
3032: where pet.classification_id in (p_ee_classification, p_er_classification)
3033: and (pet.legislation_code = 'FR' or pet.legislation_code is null)

Line 3449: from pay_action_interlocks arclck

3445: ,'CONTRIBUTIONS') balcat
3446: , db2.defined_balance_id defbal
3447: , max(aa.assignment_action_id) assignment_action_id
3448: , nvl(fcu.group_code, pet.element_information1) element_group
3449: from pay_action_interlocks arclck
3450: , pay_action_interlocks prelck
3451: , pay_balance_types b
3452: , pay_run_balances rb
3453: , pay_defined_balances db

Line 3450: , pay_action_interlocks prelck

3446: , db2.defined_balance_id defbal
3447: , max(aa.assignment_action_id) assignment_action_id
3448: , nvl(fcu.group_code, pet.element_information1) element_group
3449: from pay_action_interlocks arclck
3450: , pay_action_interlocks prelck
3451: , pay_balance_types b
3452: , pay_run_balances rb
3453: , pay_defined_balances db
3454: , pay_payroll_actions pa

Line 3582: ,pay_action_interlocks arc_lock

3578: ,pay_element_types_f pet
3579: ,pay_input_values_f_tl piv
3580: ,pay_payroll_actions run_payact
3581: ,pay_assignment_actions run_assact
3582: ,pay_action_interlocks arc_lock
3583: ,pay_action_interlocks pre_lock
3584: ,pay_entry_process_details epd
3585: ,per_time_periods ptp_date
3586: ,pay_payroll_actions ppa_date

Line 3583: ,pay_action_interlocks pre_lock

3579: ,pay_input_values_f_tl piv
3580: ,pay_payroll_actions run_payact
3581: ,pay_assignment_actions run_assact
3582: ,pay_action_interlocks arc_lock
3583: ,pay_action_interlocks pre_lock
3584: ,pay_entry_process_details epd
3585: ,per_time_periods ptp_date
3586: ,pay_payroll_actions ppa_date
3587: ,pay_assignment_actions paa_date