APPS.PAY_PAYWSMEE_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 323: pay_assignment_actions ASGT_ACTION,

319: cursor recurring_entries is
320: --
321: select 'Y'
322: from pay_run_results RESULT,
323: pay_assignment_actions ASGT_ACTION,
324: pay_payroll_actions PAY_ACTION,
325: per_time_periods PERIOD
326: where result.source_id = nvl (p_original_entry_id, p_element_entry_id)
327: and result.status <> 'U'

Line 349: pay_assignment_actions paa,

345: select /*+ ORDERED INDEX(ree PAY_ELEMENT_ENTRIES_F_N50)*/
346: 'Y'
347: from pay_element_entries_f oee,
348: pay_element_entries_f ree,
349: pay_assignment_actions paa,
350: pay_payroll_actions pac,
351: per_time_periods period
352: where oee.element_entry_id = p_element_entry_id
353: and p_effective_date between oee.effective_start_date

Line 629: -- , pay_assignment_actions asa

625: -- from pay_element_types_f ety
626: -- , pay_element_links_f elk
627: -- , pay_element_entries_f ent
628: -- , pay_payroll_actions pya
629: -- , pay_assignment_actions asa
630: -- where p_use_qpay_excl_model = 'Y'
631: -- /*
632: -- * Ensure entry does not exist in list of exclusions
633: -- */

Line 686: -- , pay_assignment_actions asa2

682: -- )
683: -- )
684: -- and (not exists ( select 'x'
685: -- from pay_run_results pr1
686: -- , pay_assignment_actions asa2
687: -- where pr1.source_id = ent.element_entry_id
688: -- and pr1.source_type = 'E'
689: -- and pr1.status <> 'U'
690: -- and pr1.assignment_action_id = asa2.assignment_action_id

Line 694: -- from pay_assignment_actions asa3

690: -- and pr1.assignment_action_id = asa2.assignment_action_id
691: -- and ( asa2.source_action_id <> p_asgt_act_id
692: -- or ( asa2.assignment_action_id <> p_asgt_act_id
693: -- and not exists ( select 'x'
694: -- from pay_assignment_actions asa3
695: -- where asa3.assignment_action_id = pr1.assignment_action_id
696: -- and asa3.source_action_id = p_asgt_act_id
697: -- )
698: -- )

Line 1664: pay_assignment_actions ASGT_ACT,

1660: --
1661: cursor csr_original_date_earned (ee_id number) is
1662: select PAY_ACT.date_earned
1663: from pay_entry_process_details ENTRY_PROC,
1664: pay_assignment_actions ASGT_ACT,
1665: pay_payroll_actions PAY_ACT
1666: where ENTRY_PROC.element_entry_id = ee_id
1667: and ENTRY_PROC.source_asg_action_id = ASGT_ACT.assignment_action_id
1668: and ASGT_ACT.payroll_action_id = PAY_ACT.payroll_action_id;