eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_FR_OVERTIME dependencies on PAY_ASSIGNMENT_ACTIONS

Line 579: from pay_assignment_actions a

575: p_range_start_chr varchar2,
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

Line 1361: from pay_assignment_actions a

1357: p_retr_ele_id number,
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

Line 1451: from pay_assignment_actions a

1447: p_end_iv number, p_start_date_chr varchar2,
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