DBA Data[Home] [Help]

APPS.PAY_PAYWSMEE_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 324: pay_payroll_actions PAY_ACTION,

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

Line 350: pay_payroll_actions pac,

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

Line 628: -- , pay_payroll_actions pya

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

Line 1665: pay_payroll_actions PAY_ACT

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