DBA Data[Home] [Help]

APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on PAY_PAYROLL_ACTIONS

Line 588: pay_payroll_actions ppa,

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

Line 9485: ,pay_payroll_actions e

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

Line 9683: ,pay_payroll_actions e

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