APPS.HRI_OPL_SUPH_HST dependencies on PER_ALL_ASSIGNMENTS_F

Line 94: ,person_id per_all_assignments_f.person_id%TYPE

90:
91: -- Information to be held for each link in a chain
92: TYPE g_link_record_type IS RECORD
93: (chain_id NUMBER
94: ,person_id per_all_assignments_f.person_id%TYPE
95: ,assignment_id per_all_assignments_f.assignment_id%TYPE
96: ,business_group_id per_all_assignments_f.business_group_id%TYPE
97: ,asg_status_type_id per_all_assignments_f.assignment_status_type_id%TYPE
98: ,start_date DATE

Line 95: ,assignment_id per_all_assignments_f.assignment_id%TYPE

91: -- Information to be held for each link in a chain
92: TYPE g_link_record_type IS RECORD
93: (chain_id NUMBER
94: ,person_id per_all_assignments_f.person_id%TYPE
95: ,assignment_id per_all_assignments_f.assignment_id%TYPE
96: ,business_group_id per_all_assignments_f.business_group_id%TYPE
97: ,asg_status_type_id per_all_assignments_f.assignment_status_type_id%TYPE
98: ,start_date DATE
99: ,relative_level PLS_INTEGER

Line 96: ,business_group_id per_all_assignments_f.business_group_id%TYPE

92: TYPE g_link_record_type IS RECORD
93: (chain_id NUMBER
94: ,person_id per_all_assignments_f.person_id%TYPE
95: ,assignment_id per_all_assignments_f.assignment_id%TYPE
96: ,business_group_id per_all_assignments_f.business_group_id%TYPE
97: ,asg_status_type_id per_all_assignments_f.assignment_status_type_id%TYPE
98: ,start_date DATE
99: ,relative_level PLS_INTEGER
100: ,orphan_flag VARCHAR2(30));

Line 97: ,asg_status_type_id per_all_assignments_f.assignment_status_type_id%TYPE

93: (chain_id NUMBER
94: ,person_id per_all_assignments_f.person_id%TYPE
95: ,assignment_id per_all_assignments_f.assignment_id%TYPE
96: ,business_group_id per_all_assignments_f.business_group_id%TYPE
97: ,asg_status_type_id per_all_assignments_f.assignment_status_type_id%TYPE
98: ,start_date DATE
99: ,relative_level PLS_INTEGER
100: ,orphan_flag VARCHAR2(30));
101:

Line 865: FROM per_all_assignments_f asg

861: -- Delete records that are not primary employee assignment change events
862: DELETE /*+ PARALLEL(eq, default,default)*/ hri_eq_sprvsr_hrchy_chgs eq
863: WHERE assignment_id NOT IN
864: (SELECT assignment_id
865: FROM per_all_assignments_f asg
866: WHERE eq.assignment_id = asg.assignment_id
867: AND primary_flag = 'Y'
868: AND assignment_type IN ('E','C')
869: AND asg.effective_end_date >= eq.erlst_evnt_effective_date);

Line 880: FROM per_all_assignments_f asg

876: -- Set person ids on event queue
877: UPDATE hri_eq_sprvsr_hrchy_chgs eq
878: SET person_id =
879: (SELECT person_id
880: FROM per_all_assignments_f asg
881: WHERE eq.assignment_id = asg.assignment_id
882: AND rownum = 1);
883:
884: EXCEPTION

Line 1149: per_all_assignments_f sec_pre

1145: THEN 'EMP'
1146: ELSE 'CWK'
1147: END ptyp_wrktyp_fk
1148: FROM
1149: per_all_assignments_f sec_pre
1150: ,per_all_assignments_f sec_post
1151: WHERE sec_pre.supervisor_id = p_trn_psn_id
1152: AND sec_post.assignment_id = sec_pre.assignment_id
1153: AND sec_post.supervisor_id = sec_pre.supervisor_id

Line 1150: ,per_all_assignments_f sec_post

1146: ELSE 'CWK'
1147: END ptyp_wrktyp_fk
1148: FROM
1149: per_all_assignments_f sec_pre
1150: ,per_all_assignments_f sec_post
1151: WHERE sec_pre.supervisor_id = p_trn_psn_id
1152: AND sec_post.assignment_id = sec_pre.assignment_id
1153: AND sec_post.supervisor_id = sec_pre.supervisor_id
1154: AND sec_post.primary_flag = 'N'