APPS.PAY_FR_OVERTIME dependencies on PAY_INPUT_VALUES_F

Line 581: ,pay_input_values_f i

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
585: where i.element_type_id = r.element_type_id

Line 583: ,pay_input_values_f i2

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'
587: and i.business_group_id is null

Line 771: , pay_input_values_f iv

767: and et.element_name in ('FR_OVERTIME_WEEK','FR_OVERTIME_EXCEPTION_WEEK')
768: and exists
769: (select null
770: from pay_element_entry_values_f eev
771: , pay_input_values_f iv
772: where eev.input_value_id = iv.input_value_id
773: and eev.element_entry_id = ee.element_entry_id
774: and iv.name = 'Start Date'
775: and eev.screen_entry_value =

Line 781: , pay_input_values_f iv

777: )
778: and exists
779: (select null
780: from pay_element_entry_values_f eev
781: , pay_input_values_f iv
782: where eev.input_value_id = iv.input_value_id
783: and eev.element_entry_id = ee.element_entry_id
784: and iv.name = 'End Date'
785: and eev.screen_entry_value =

Line 1363: ,pay_input_values_f i

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
1367: where i.element_type_id = r.element_type_id

Line 1365: ,pay_input_values_f i2

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'
1369: and i.business_group_id is null

Line 1433: pay_input_values_f piv

1429: max(decode(piv.name,p_value_input,piv.input_value_id)) value_iv,
1430: max(decode(piv.name,p_start_input,piv.input_value_id)) start_iv,
1431: max(decode(piv.name,p_end_input, piv.input_value_id)) end_iv
1432: from pay_element_types_f pet,
1433: pay_input_values_f piv
1434: where pet.element_name = p_element
1435: and (pet.legislation_code = 'FR' or
1436: pet.business_group_id = p_business_group_id)
1437: and p_date_earned between pet.effective_start_date