APPS.PAY_MX_ANNUAL_WRI dependencies on PER_ASSIGNMENTS_F

Line 163: FROM per_assignments_f paf,

159: g_end_date);
160:
161: p_sqlstr := '
162: SELECT DISTINCT paf.person_id
163: FROM per_assignments_f paf,
164: pay_payroll_actions ppa_sua,
165: pay_assignment_actions paa_sua
166: WHERE ppa_sua.payroll_action_id = paa_sua.payroll_action_id
167: AND paa_sua.assignment_id = paf.assignment_id

Line 211: FROM per_assignments_f paf,

207: paf.assignment_id,
208: paa_sua.assignment_action_id,
209: paf.primary_flag,
210: paf.effective_end_date
211: FROM per_assignments_f paf,
212: pay_payroll_actions ppa_sua,
213: pay_assignment_actions paa_sua,
214: pay_action_interlocks lck,
215: pay_action_information pai

Line 254: FROM per_assignments_f paf,

250: paf.assignment_id,
251: paa_sua.assignment_action_id,
252: paf.primary_flag,
253: paf.effective_end_date
254: FROM per_assignments_f paf,
255: pay_payroll_actions ppa_sua,
256: pay_assignment_actions paa_sua,
257: pay_action_interlocks lck,
258: pay_action_information pai,

Line 301: lv_primary_flag per_assignments_f.primary_flag%type;

297: ln_asg_id number;
298: ln_sua_asg_act number;
299: ln_wri_asg_act number;
300: ld_asg_end_date date;
301: lv_primary_flag per_assignments_f.primary_flag%type;
302:
303: BEGIN
304: l_proc_name := g_proc_name || 'ACTION_CREATION';
305: hr_utility_trace ('Entering '||l_proc_name);

Line 437: per_assignments_f paf

433:
434: CURSOR csr_person (cp_asg_act_id number) IS
435: SELECT DISTINCT paf.person_id
436: FROM pay_assignment_actions paa,
437: per_assignments_f paf
438: WHERE paf.assignment_id = paa.assignment_id
439: AND paa.assignment_action_id = cp_asg_act_id;
440:
441: CURSOR csr_person_info (cp_person_id number) IS