DBA Data[Home] [Help]

APPS.PAY_NO_ARCHIVE_ABSENCE dependencies on HR_SOFT_CODING_KEYFLEX

Line 331: hr_soft_coding_keyflex hsc,

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
334: and paa.absence_attendance_type_id = paat.absence_attendance_type_id
335: and paaf.person_id = papf.person_id

Line 369: hr_soft_coding_keyflex hsc,

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
373: and hsc.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id