APPS.PAY_FR_OVERTIME dependencies on PAY_RUN_RESULT_VALUES

Line 582: ,pay_run_result_values rr

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
585: where i.element_type_id = r.element_type_id
586: and i.name = 'End Date'

Line 584: ,pay_run_result_values rr2

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
585: where i.element_type_id = r.element_type_id
586: and i.name = 'End Date'
587: and i.business_group_id is null
588: and i.legislation_code = 'FR'

Line 1364: ,pay_run_result_values rr

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
1367: where i.element_type_id = r.element_type_id
1368: and i.name = 'End Date'

Line 1366: ,pay_run_result_values rr2

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
1367: where i.element_type_id = r.element_type_id
1368: and i.name = 'End Date'
1369: and i.business_group_id is null
1370: and i.legislation_code = 'FR'

Line 1453: , pay_run_result_values rrsd

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
1457: and a.assignment_action_id = r.assignment_action_id

Line 1454: , pay_run_result_values rred

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
1457: and a.assignment_action_id = r.assignment_action_id
1458: and r.element_type_id = p_element_type_id

Line 1455: , pay_run_result_values rr

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
1457: and a.assignment_action_id = r.assignment_action_id
1458: and r.element_type_id = p_element_type_id
1459: and rr.run_result_id = r.run_result_id