DBA Data[Home] [Help]

APPS.PAY_IN_INDIA_BENEFITS dependencies on PAY_RUN_RESULT_VALUES

Line 1546: FROM pay_run_result_values TARGET

1542: CURSOR csr_ltc_run_result( p_asg_action_id IN NUMBER,
1543: p_balance_type_id IN VARCHAR2)
1544: IS
1545: SELECT sum(nvl(target.result_value,0) )
1546: FROM pay_run_result_values TARGET
1547: ,pay_balance_feeds_f FEED
1548: ,pay_run_results RR
1549: ,pay_assignment_actions ASSACT
1550: ,pay_assignment_actions BAL_ASSACT

Line 1554: ,pay_run_result_values srcVal

1550: ,pay_assignment_actions BAL_ASSACT
1551: ,pay_payroll_actions PACT
1552: ,pay_payroll_actions BACT
1553: ,pay_input_values_f piv
1554: ,pay_run_result_values srcVal
1555: ,pay_input_values_f srcInp
1556: where BAL_ASSACT.assignment_action_id = p_asg_action_id
1557: AND BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
1558: AND FEED.input_value_id = TARGET.input_value_id