DBA Data[Home] [Help]

APPS.PQP_GB_CPX_EXTRACT_FUNCTIONS dependencies on PAY_PAYROLL_ACTIONS

Line 315: pay_payroll_actions ppa,

311: )
312: IS
313: SELECT DISTINCT (ptp.end_date) end_date
314: FROM per_time_periods ptp,
315: pay_payroll_actions ppa,
316: pay_assignment_actions paa
317: WHERE ptp.time_period_id = ppa.time_period_id
318: AND ppa.effective_date BETWEEN ptp.start_date
319: AND ptp.end_date

Line 621: pay_payroll_actions pact,

617: IS
618: SELECT NVL (SUM (result_value), 0) result_value
619: FROM pay_run_result_values target,
620: pay_run_results rr,
621: pay_payroll_actions pact,
622: pay_assignment_actions assact,
623: pay_payroll_actions bact,
624: pay_assignment_actions bal_assact
625: WHERE bal_assact.assignment_action_id = c_assignment_action_id

Line 623: pay_payroll_actions bact,

619: FROM pay_run_result_values target,
620: pay_run_results rr,
621: pay_payroll_actions pact,
622: pay_assignment_actions assact,
623: pay_payroll_actions bact,
624: pay_assignment_actions bal_assact
625: WHERE bal_assact.assignment_action_id = c_assignment_action_id
626: AND bal_assact.payroll_action_id = bact.payroll_action_id
627: AND NVL (target.result_value, '0') <> '0'