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.

[Home] [Help]

APPS.HRI_OPL_WMV dependencies on PER_ASSIGNMENT_BUDGET_VALUES_F

Line 190: OR EXISTS (SELECT null FROM per_assignment_budget_values_f abv

186: AND (asg.effective_start_date
187: BETWEEN ppa.start_date AND ppa.effective_date
188: OR asg.effective_end_date
189: BETWEEN ppa.start_date AND ppa.effective_date
190: OR EXISTS (SELECT null FROM per_assignment_budget_values_f abv
191: WHERE abv.assignment_id = asg.assignment_id
192: AND (abv.effective_start_date
193: BETWEEN ppa.start_date AND ppa.effective_date
194: OR abv.effective_end_date

Line 230: OR EXISTS (SELECT null FROM per_assignment_budget_values_f abv

226: AND (asg.effective_start_date
227: BETWEEN g_collect_from_date AND g_collect_to_date
228: OR asg.effective_end_date
229: BETWEEN g_collect_from_date AND g_collect_to_date
230: OR EXISTS (SELECT null FROM per_assignment_budget_values_f abv
231: WHERE abv.assignment_id = asg.assignment_id
232: AND (abv.effective_start_date
233: BETWEEN g_collect_from_date AND g_collect_to_date
234: OR abv.effective_end_date

Line 937: per_assignment_budget_values_f abv

933: ,GREATEST(abv.last_update_date, asg.last_update_date)
934: last_change_date
935: ,pos.final_process_date final_process_date
936: FROM
937: per_assignment_budget_values_f abv
938: ,per_all_assignments_f asg
939: ,per_assignment_status_types ast
940: ,per_periods_of_service pos
941: WHERE abv.assignment_id = asg.assignment_id

Line 987: per_assignment_budget_values_f abv

983: ,GREATEST(abv.last_update_date, asg.last_update_date)
984: last_change_date
985: ,pos.final_process_date final_process_date
986: FROM
987: per_assignment_budget_values_f abv
988: ,per_all_assignments_f asg
989: ,per_assignment_status_types ast
990: ,per_periods_of_service pos
991: WHERE abv.assignment_id = asg.assignment_id

Line 1003: FROM per_assignment_budget_values_f abv_next

999: AND asg.effective_start_date < abv.effective_end_date + 1
1000: AND abv.effective_end_date + 1 <= asg.effective_end_date
1001: AND NOT EXISTS
1002: (SELECT null
1003: FROM per_assignment_budget_values_f abv_next
1004: WHERE abv_next.assignment_id = abv.assignment_id
1005: AND abv_next.unit = abv.unit
1006: AND abv_next.effective_start_date = abv.effective_end_date + 1)
1007: UNION ALL

Line 1040: FROM per_assignment_budget_values_f abv

1036: BETWEEN asg.effective_start_date AND asg.effective_end_date
1037: AND g_full_refresh = 'Y'))
1038: AND NOT EXISTS
1039: (SELECT null
1040: FROM per_assignment_budget_values_f abv
1041: WHERE abv.assignment_id = asg.assignment_id
1042: AND abv.unit = p_bmt_code
1043: AND GREATEST(asg.effective_start_date, g_collect_from_date)
1044: BETWEEN abv.effective_start_date AND abv.effective_end_date)

Line 1062: per_assignment_budget_values_f abv

1058: ,GREATEST(abv.last_update_date, next_asg.last_update_date)
1059: last_change_date
1060: ,pos.final_process_date final_process_date
1061: FROM
1062: per_assignment_budget_values_f abv
1063: ,per_all_assignments_f asg
1064: ,per_all_assignments_f next_asg
1065: ,per_assignment_status_types ast
1066: ,per_periods_of_service pos