APPS.PAY_NO_ARCHIVE_ABSENCE dependencies on PER_ALL_ASSIGNMENTS_F

Line 304: l_pos_assignment_id per_all_assignments_f.assignment_id%type;

300: l_quater_start date;
301: l_quater_end date;
302: l_full_time_percentage number;
303: l_hr_work_schedule number;
304: l_pos_assignment_id per_all_assignments_f.assignment_id%type;
305: l_total_possible_working_days number:=0;
306:
307: /* Cursors */
308:

Line 329: per_all_assignments_f paaf,

325: paa.abs_information3,
326: paa.abs_information4
327: from per_absence_attendances paa,
328: per_all_people_f papf,
329: per_all_assignments_f paaf,
330: per_absence_attendance_types paat,
331: hr_soft_coding_keyflex hsc,
332: hr_organization_information hoi
333: where paa.person_id = papf.person_id

Line 352: per_all_assignments_f paaf1

348: and not exists (select '1'
349: from
350: pay_element_entries_f peef,
351: pay_element_types_f petf,
352: per_all_assignments_f paaf1
353: where peef.element_type_id = petf.element_type_id
354: and paaf1.person_id = papf.person_id
355: and peef.assignment_id = paaf1.assignment_id
356: and petf.element_name = 'Sickness Unpaid'

Line 368: per_all_assignments_f paaf,

364: ,csr_v_effective_date date
365: ,csr_v_sex varchar2) is
366: select paaf.assignment_id
367: from per_all_people_f papf,
368: per_all_assignments_f paaf,
369: hr_soft_coding_keyflex hsc,
370: hr_organization_information hoi
371: where paaf.person_id = papf.person_id
372: and papf.business_group_id = csr_v_business_group_id

Line 386: per_all_assignments_f paaf1

382: and not exists (select '1'
383: from
384: pay_element_entries_f peef,
385: pay_element_types_f petf,
386: per_all_assignments_f paaf1
387: where peef.element_type_id = petf.element_type_id
388: and paaf1.person_id = papf.person_id
389: and peef.assignment_id = paaf1.assignment_id
390: and petf.element_name = 'Sickness Unpaid'