APPS.HRI_OPL_ASGN_EVENTS dependencies on PER_ALL_ASSIGNMENTS_F

Line 448: ,per_all_assignments_f asg

444: orgh.orgh_sup_organztn_fk
445: ,GREATEST(eq.erlst_evnt_effective_date, asg.effective_start_date)
446: FROM
447: hri_eq_asgn_evnts eq
448: ,per_all_assignments_f asg
449: ,hri_cs_orgh_ct orgh
450: WHERE eq.assignment_id = asg.assignment_id
451: AND eq.erlst_evnt_effective_date <= asg.effective_end_date
452: AND asg.organization_id = orgh.orgh_organztn_fk;

Line 495: ,per_all_assignments_f asg

491: ,GREATEST(eq.erlst_evnt_effective_date, asg.effective_start_date)
492: ,'ASG_EVENT_CURR'
493: FROM
494: hri_eq_asgn_evnts eq
495: ,per_all_assignments_f asg
496: ,hri_cs_suph suph
497: WHERE eq.assignment_id = asg.assignment_id
498: AND eq.erlst_evnt_effective_date <= asg.effective_end_date
499: AND asg.supervisor_id = suph.sub_person_id

Line 1371: FROM per_all_assignments_f asg

1367: ,pos.adjusted_svc_date pow_start_date_adj
1368: ,hpt.prsntyp_sk_pk prsntyp_sk_fk
1369: ,nvl(decode(hpt.include_flag_code,'Y',1,0),1) summarization_rqd_ind
1370: ,hpt.wkth_wktyp_code wkth_wktyp_code
1371: FROM per_all_assignments_f asg
1372: ,per_assignment_status_types ast
1373: ,per_periods_of_service pos
1374: ,per_periods_of_placement pop
1375: ,per_person_type_usages_f ptu

Line 2310: per_all_assignments_f asg

2306: --
2307: ,NVL(pro.pay_proposal_id,-1) pay_proposal_id
2308: ,NVL(pet.input_currency_code, 'NA_EDW') currency_code
2309: FROM
2310: per_all_assignments_f asg
2311: ,per_pay_bases ppb
2312: ,per_pay_proposals pro
2313: ,pay_input_values_f piv
2314: ,pay_element_types_f pet

Line 2771: FROM per_all_assignments_f asg

2767: l_pow_band_sk_fk NUMBER;
2768: --
2769: CURSOR c_prjctd_end_dt IS
2770: SELECT min(asg.projected_assignment_end)
2771: FROM per_all_assignments_f asg
2772: WHERE asg.person_id = p_person_id
2773: AND asg.primary_flag = 'Y'
2774: --
2775: -- 4469175 incase if rehire of placement, the extension date should be

Line 4688: FROM per_all_assignments_f asg,

4684: 0 perf_rating_change_ind,
4685: 0 perf_band_change_ind,
4686: hpt.prsntyp_sk_pk prsntyp_sk_fk,
4687: 1 summarization_rqd_ind
4688: FROM per_all_assignments_f asg,
4689: per_periods_of_service pos,
4690: hri_cs_prsntyp_ct hpt,
4691: per_person_type_usages_f ptu
4692: WHERE asg.assignment_type = 'E'

Line 4974: FROM per_all_assignments_f asgn

4970: p_sqlstr :=
4971: 'SELECT /*+ PARALLEL(asgn, DEFAULT, DEFAULT) */
4972: DISTINCT
4973: asgn.assignment_id object_id
4974: FROM per_all_assignments_f asgn
4975: WHERE asgn.assignment_type in (''E'',''C'')
4976: AND asgn.effective_end_date >= to_date(''' ||
4977: to_char(g_refresh_start_date, 'DD-MM-YYYY') ||
4978: ''',''DD-MM-YYYY'') - 1

Line 5160: FROM per_all_assignments_f asg

5156: OPEN c_asg_to_process FOR
5157: SELECT DISTINCT
5158: asg.assignment_id assignment_id,
5159: l_system_date change_date
5160: FROM per_all_assignments_f asg
5161: ,per_assignment_status_types ast
5162: WHERE asg.assignment_type in ('E','C')
5163: AND asg.assignment_id BETWEEN p_start_object_id and p_end_object_id
5164: AND ast.assignment_status_type_id = asg.assignment_status_type_id