DBA Data[Home] [Help]

APPS.PAY_IN_INDIA_BENEFITS dependencies on PAY_RUN_RESULT_VALUES

Line 1489: FROM pay_run_result_values TARGET

1485: CURSOR csr_ltc_run_result( p_asg_action_id IN NUMBER,
1486: p_balance_type_id IN VARCHAR2)
1487: IS
1488: SELECT sum(nvl(target.result_value,0) )
1489: FROM pay_run_result_values TARGET
1490: ,pay_balance_feeds_f FEED
1491: ,pay_run_results RR
1492: ,pay_assignment_actions ASSACT
1493: ,pay_assignment_actions BAL_ASSACT

Line 1497: ,pay_run_result_values srcVal

1493: ,pay_assignment_actions BAL_ASSACT
1494: ,pay_payroll_actions PACT
1495: ,pay_payroll_actions BACT
1496: ,pay_input_values_f piv
1497: ,pay_run_result_values srcVal
1498: ,pay_input_values_f srcInp
1499: where BAL_ASSACT.assignment_action_id = p_asg_action_id
1500: AND BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
1501: AND FEED.input_value_id = TARGET.input_value_id