DBA Data[Home] [Help]

APPS.PAY_FR_OVERTIME dependencies on PAY_RUN_RESULTS

Line 580: ,pay_run_results r

576: p_range_end_chr varchar2) is
577: select /*+ordered use_nl(i i2) */ rr.result_value,
578: sum(fnd_number.canonical_to_number(rr2.result_value))
579: from pay_assignment_actions a
580: ,pay_run_results r
581: ,pay_input_values_f i
582: ,pay_run_result_values rr
583: ,pay_input_values_f i2
584: ,pay_run_result_values rr2

Line 1362: ,pay_run_results r

1358: p_week_end in varchar2) is
1359: select /*+ordered use_nl(i i2) */
1360: decode(sum(rr2.result_value),null,'N',0,'N','Y')
1361: from pay_assignment_actions a
1362: ,pay_run_results r
1363: ,pay_input_values_f i
1364: ,pay_run_result_values rr
1365: ,pay_input_values_f i2
1366: ,pay_run_result_values rr2

Line 1452: , pay_run_results r

1448: p_end_date_chr varchar2) is
1449: select /*+ORDERED */
1450: sum(to_number(rr.result_value))
1451: from pay_assignment_actions a
1452: , pay_run_results r
1453: , pay_run_result_values rrsd
1454: , pay_run_result_values rred
1455: , pay_run_result_values rr
1456: where a.assignment_id = p_assignment_id