APPS.HRI_OPL_WMV dependencies on PER_ALL_ASSIGNMENTS_F

Line 161: per_all_assignments_f asg

157: sqlstr :=
158: 'SELECT DISTINCT
159: asg.person_id
160: FROM
161: per_all_assignments_f asg
162: ,pay_payroll_actions ppa
163: WHERE ppa.payroll_action_id = :payroll_action_id
164: AND asg.assignment_type = ''E''
165: AND (ppa.start_date

Line 182: per_all_assignments_f asg

178: sqlstr :=
179: 'SELECT DISTINCT
180: asg.person_id
181: FROM
182: per_all_assignments_f asg
183: ,pay_payroll_actions ppa
184: WHERE ppa.payroll_action_id = :payroll_action_id
185: AND asg.assignment_type = ''E''
186: AND (asg.effective_start_date

Line 223: per_all_assignments_f asg

219: FROM
220: (SELECT DISTINCT
221: asg.assignment_id assignment_id
222: FROM
223: per_all_assignments_f asg
224: WHERE asg.assignment_type = 'E'
225: AND asg.person_id BETWEEN stperson AND endperson
226: AND (asg.effective_start_date
227: BETWEEN g_collect_from_date AND g_collect_to_date

Line 274: per_all_assignments_f asg

270: /* all employee assignments which exist at any point in the collection range */
271: (SELECT DISTINCT
272: asg.assignment_id assignment_id
273: FROM
274: per_all_assignments_f asg
275: WHERE asg.assignment_type = 'E'
276: AND asg.person_id BETWEEN stperson AND endperson
277: AND (g_collect_from_date
278: BETWEEN asg.effective_start_date AND asg.effective_end_date

Line 938: ,per_all_assignments_f asg

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
942: AND asg.assignment_id = p_assignment_id

Line 988: ,per_all_assignments_f asg

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
992: AND asg.assignment_id = p_assignment_id

Line 1026: per_all_assignments_f asg

1022: ,asg.primary_flag primary_flag
1023: ,asg.last_update_date last_change_date
1024: ,pos.final_process_date final_process_date
1025: FROM
1026: per_all_assignments_f asg
1027: ,per_assignment_status_types ast
1028: ,per_periods_of_service pos
1029: WHERE asg.assignment_id = p_assignment_id
1030: AND pos.period_of_service_id = asg.period_of_service_id

Line 1063: ,per_all_assignments_f asg

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
1067: WHERE abv.assignment_id = asg.assignment_id

Line 1064: ,per_all_assignments_f next_asg

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
1067: WHERE abv.assignment_id = asg.assignment_id
1068: AND asg.assignment_id = p_assignment_id

Line 1303: per_all_assignments_f asg

1299: CURSOR asg_csr IS
1300: SELECT DISTINCT
1301: asg.assignment_id
1302: FROM
1303: per_all_assignments_f asg
1304: WHERE (asg.business_group_id = p_business_group_id
1305: OR p_business_group_id IS NULL)
1306: AND asg.assignment_type = 'E'
1307: AND (g_collect_from_date

Line 1450: per_all_assignments_f asg

1446: ,asg.period_of_service_id period_of_service_id
1447: ,asg.primary_flag primary_flag
1448: ,asg.last_update_date last_change_date
1449: FROM
1450: per_all_assignments_f asg
1451: ,per_assignment_status_types ast
1452: ,per_periods_of_service pos
1453: WHERE pos.period_of_service_id = asg.period_of_service_id
1454: AND ast.assignment_status_type_id = asg.assignment_status_type_id