DBA Data[Home] [Help]

APPS.PAY_PAYWSMEE_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 307: pay_payroll_actions PAY_ACTION,

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'
311: and result.source_type = 'E'

Line 332: pay_payroll_actions pac,

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
336: and oee.effective_end_date

Line 604: -- , pay_payroll_actions pya

600: -- select 'Y'
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

Line 1636: pay_payroll_actions PAY_ACT

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;
1640: --