APPS.PER_PERFRMMO_XMLP_PKG dependencies on PER_JOBS

Line 98: lid per_jobs.job_id%type;

94: lc_start_reason varchar2(80);
95: lc_end_reason varchar2(80);
96: ld_effective_start_date date;
97:
98: lid per_jobs.job_id%type;
99:
100: begin
101: hr_utility.set_location('Entered C_GET_ASG formula', 5);
102: begin

Line 114: per_jobs j,

110: lc_start_job,
111: lid,
112: lc_start_job_pcs
113: from per_all_assignments_f a,
114: per_jobs j,
115: per_jobs_tl jbt,
116: hr_soft_coding_keyflex s
117: where a.person_id = PERSON_ID1
118: and a.primary_flag = 'Y'

Line 115: per_jobs_tl jbt,

111: lid,
112: lc_start_job_pcs
113: from per_all_assignments_f a,
114: per_jobs j,
115: per_jobs_tl jbt,
116: hr_soft_coding_keyflex s
117: where a.person_id = PERSON_ID1
118: and a.primary_flag = 'Y'
119: and a.effective_start_date = START_DATE

Line 154: per_jobs j,

150: lc_end_job,
151: lid,
152: lc_end_job_pcs
153: from per_all_assignments_f a,
154: per_jobs j,
155: per_jobs_tl jbt,
156: hr_soft_coding_keyflex s
157: where a.person_id = PERSON_ID1
158: and a.primary_flag = 'Y'

Line 155: per_jobs_tl jbt,

151: lid,
152: lc_end_job_pcs
153: from per_all_assignments_f a,
154: per_jobs j,
155: per_jobs_tl jbt,
156: hr_soft_coding_keyflex s
157: where a.person_id = PERSON_ID1
158: and a.primary_flag = 'Y'
159: and a.effective_end_date = END_DATE