DBA Data[Home] [Help]

APPS.PQP_INI_BAL dependencies on PAY_RUN_RESULT_VALUES

Line 1257: ,pay_run_result_values TARGET

1253: select /*+ RULE*/ nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) *
1254: FEED.scale),0) tot
1255: from
1256: pay_balance_feeds_f FEED
1257: ,pay_run_result_values TARGET
1258: ,pay_run_results RR
1259: ,pay_payroll_actions PACT
1260: ,pay_assignment_actions ASSACT
1261: ,pay_payroll_actions BACT

Line 1418: FROM pay_run_result_values TARGET

1414: ,cp_payroll_action_id NUMBER)
1415: is
1416: SELECT nvl((fnd_number.canonical_to_number(TARGET.result_value)
1417: * FEED.scale),0) tot
1418: FROM pay_run_result_values TARGET
1419: , pay_balance_feeds_f FEED
1420: , pay_run_results RR
1421: , pay_assignment_actions ASSACT
1422: , pay_assignment_actions BAL_ASSACT

Line 1555: ,pay_run_result_values prrv

1551: ,piv.name
1552: ,prrv.result_value entry_value
1553: ,piv.display_sequence
1554: FROM pay_input_values_f piv
1555: ,pay_run_result_values prrv
1556: WHERE prrv.run_result_id = cp_run_result_id
1557: AND piv.input_value_id=prrv.input_value_id
1558: AND piv.name IN ('Vehicle Type'
1559: ,'Rate Type'