DBA Data[Home] [Help]

APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on PAY_PAYROLL_ACTIONS

Line 589: pay_payroll_actions ppa,

585: cursor c_paa is
586: select paa.assignment_action_id
587: from pay_assignment_actions paa,
588: per_all_assignments_f paf,
589: pay_payroll_actions ppa,
590: pay_action_classifications pac
591: where paf.person_id = p_person_id
592: and paa.assignment_id = paf.assignment_id
593: and paa.tax_unit_id = l_tax_unit_id

Line 9486: ,pay_payroll_actions e

9482: SELECT NVL(SUM(a.result_value),0) result_value
9483: FROM pay_run_result_values a
9484: ,pay_element_types_f b
9485: ,pay_assignment_actions d
9486: ,pay_payroll_actions e
9487: ,per_time_periods g
9488: ,pay_run_results h
9489: ,ben_acty_base_rt_f i
9490: ,pay_input_values_f j

Line 9684: ,pay_payroll_actions e

9680: SELECT a.result_value
9681: FROM pay_run_result_values a
9682: ,pay_element_types_f b
9683: ,pay_assignment_actions d
9684: ,pay_payroll_actions e
9685: ,per_time_periods g
9686: ,pay_run_results h
9687: ,ben_acty_base_rt_f i
9688: ,pay_input_values_f j