APPS.PAY_PAYWSMEE_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 306: pay_assignment_actions ASGT_ACTION,

302: cursor recurring_entries is
303: --
304: select 'Y'
305: from pay_run_results RESULT,
306: pay_assignment_actions ASGT_ACTION,
307: pay_payroll_actions PAY_ACTION,
308: per_time_periods PERIOD
309: where result.source_id = nvl (p_original_entry_id, p_element_entry_id)
310: and result.status <> 'U'

Line 331: pay_assignment_actions paa,

327: select /*+ ORDERED INDEX(ree PAY_ELEMENT_ENTRIES_F_N50)*/
328: 'Y'
329: from pay_element_entries_f oee,
330: pay_element_entries_f ree,
331: pay_assignment_actions paa,
332: pay_payroll_actions pac,
333: per_time_periods period
334: where oee.element_entry_id = p_element_entry_id
335: and p_effective_date between oee.effective_start_date

Line 605: -- , pay_assignment_actions asa

601: -- from pay_element_types_f ety
602: -- , pay_element_links_f elk
603: -- , pay_element_entries_f ent
604: -- , pay_payroll_actions pya
605: -- , pay_assignment_actions asa
606: -- where p_use_qpay_excl_model = 'Y'
607: -- /*
608: -- * Ensure entry does not exist in list of exclusions
609: -- */

Line 662: -- , pay_assignment_actions asa2

658: -- )
659: -- )
660: -- and (not exists ( select 'x'
661: -- from pay_run_results pr1
662: -- , pay_assignment_actions asa2
663: -- where pr1.source_id = ent.element_entry_id
664: -- and pr1.source_type = 'E'
665: -- and pr1.status <> 'U'
666: -- and pr1.assignment_action_id = asa2.assignment_action_id

Line 670: -- from pay_assignment_actions asa3

666: -- and pr1.assignment_action_id = asa2.assignment_action_id
667: -- and ( asa2.source_action_id <> p_asgt_act_id
668: -- or ( asa2.assignment_action_id <> p_asgt_act_id
669: -- and not exists ( select 'x'
670: -- from pay_assignment_actions asa3
671: -- where asa3.assignment_action_id = pr1.assignment_action_id
672: -- and asa3.source_action_id = p_asgt_act_id
673: -- )
674: -- )

Line 1635: pay_assignment_actions ASGT_ACT,

1631: --
1632: cursor csr_original_date_earned (ee_id number) is
1633: select PAY_ACT.date_earned
1634: from pay_entry_process_details ENTRY_PROC,
1635: pay_assignment_actions ASGT_ACT,
1636: pay_payroll_actions PAY_ACT
1637: where ENTRY_PROC.element_entry_id = ee_id
1638: and ENTRY_PROC.source_asg_action_id = ASGT_ACT.assignment_action_id
1639: and ASGT_ACT.payroll_action_id = PAY_ACT.payroll_action_id;