eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NO_ARCHIVE_ABSENCE dependencies on HR_ORGANIZATION_INFORMATION

Line 311: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE,

307: /* Cursors */
308:
309:
310: Cursor csr_person_abs_details(csr_v_business_group_id number,
311: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE,
312: csr_v_start_date date,
313: csr_v_end_date date,
314: csr_v_effective_date date
315: )is select papf.person_id,

Line 332: hr_organization_information hoi

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
336: and papf.business_group_id = csr_v_business_group_id

Line 370: hr_organization_information hoi

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
374: and hoi.org_information1 = hsc.segment2