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_SE_SLSA_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 331: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE

327: l_previous_end_date DATE;
328:
329: -- Archiving the data , as this will fire once
330: CURSOR csr_legal_employer_details (
331: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE
332: ) IS
333: SELECT o1.NAME legal_employer_name, hoi2.org_information2 org_number, hoi1.organization_id legal_id
334: FROM hr_organization_units o1, hr_organization_information hoi1, hr_organization_information hoi2
335: WHERE o1.business_group_id = g_business_group_id

Line 334: FROM hr_organization_units o1, hr_organization_information hoi1, hr_organization_information hoi2

330: CURSOR csr_legal_employer_details (
331: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE
332: ) IS
333: SELECT o1.NAME legal_employer_name, hoi2.org_information2 org_number, hoi1.organization_id legal_id
334: FROM hr_organization_units o1, hr_organization_information hoi1, hr_organization_information hoi2
335: WHERE o1.business_group_id = g_business_group_id
336: AND hoi1.organization_id = o1.organization_id
337: AND hoi1.organization_id = nvl (csr_v_legal_employer_id, hoi1.organization_id)
338: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 346: p_legal_employer_id hr_organization_information.organization_id%TYPE,

342:
343: l_legal_employer_details csr_legal_employer_details%ROWTYPE;
344: /* Procedure to get the employee data */
345: PROCEDURE get_employee_data (
346: p_legal_employer_id hr_organization_information.organization_id%TYPE,
347: p_effective_start_date DATE,
348: p_effective_end_date DATE,
349: p_curr_prev_flag VARCHAR2 -- 'C' for current year and 'P' for Previous Year
350: ) IS

Line 352: p_legal_employer_id hr_organization_information.organization_id%TYPE,

348: p_effective_end_date DATE,
349: p_curr_prev_flag VARCHAR2 -- 'C' for current year and 'P' for Previous Year
350: ) IS
351: CURSOR csr_get_employee_detail (
352: p_legal_employer_id hr_organization_information.organization_id%TYPE,
353: p_effective_start_date DATE,
354: p_effective_end_date DATE
355: ) IS
356: SELECT papf.person_id, paaf.assignment_id, papf.date_of_birth, papf.sex, nvl (hsc.segment9, 100) work_percentage

Line 361: hr_organization_information hoi,

357: FROM per_all_people_f papf,
358: per_all_assignments_f paaf,
359: hr_soft_coding_keyflex hsc,
360: per_assignment_status_types past,
361: hr_organization_information hoi,
362: per_person_types ppt,
363: per_all_people_f papfs,
364: per_all_assignments_f paafs
365: WHERE paaf.person_id = papf.person_id

Line 383: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE

379: AND p_effective_end_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
380: AND p_effective_end_date BETWEEN paafs.effective_start_date AND paafs.effective_end_date;
381:
382: CURSOR csr_legal_employer_details (
383: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE
384: ) IS
385: SELECT o1.NAME legal_employer_name, hoi2.org_information2 org_number, hoi1.organization_id legal_id
386: FROM hr_organization_units o1, hr_organization_information hoi1, hr_organization_information hoi2
387: WHERE o1.business_group_id = g_business_group_id

Line 386: FROM hr_organization_units o1, hr_organization_information hoi1, hr_organization_information hoi2

382: CURSOR csr_legal_employer_details (
383: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE
384: ) IS
385: SELECT o1.NAME legal_employer_name, hoi2.org_information2 org_number, hoi1.organization_id legal_id
386: FROM hr_organization_units o1, hr_organization_information hoi1, hr_organization_information hoi2
387: WHERE o1.business_group_id = g_business_group_id
388: AND hoi1.organization_id = o1.organization_id
389: AND hoi1.organization_id = nvl (csr_v_legal_employer_id, hoi1.organization_id)
390: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 397: p_legal_employer_id hr_organization_information.organization_id%TYPE,

393: AND hoi2.org_information_context = 'SE_LEGAL_EMPLOYER_DETAILS';
394:
395: /* Cursor to get the standard work details from the 'Standard Work Details' EIT */
396: CURSOR csr_get_std_work_details (
397: p_legal_employer_id hr_organization_information.organization_id%TYPE,
398: p_year hr_organization_information.org_information1%TYPE
399: ) IS
400: SELECT org_information2 weekly_working_hours, org_information3 daily_working_hours,
401: org_information4

Line 398: p_year hr_organization_information.org_information1%TYPE

394:
395: /* Cursor to get the standard work details from the 'Standard Work Details' EIT */
396: CURSOR csr_get_std_work_details (
397: p_legal_employer_id hr_organization_information.organization_id%TYPE,
398: p_year hr_organization_information.org_information1%TYPE
399: ) IS
400: SELECT org_information2 weekly_working_hours, org_information3 daily_working_hours,
401: org_information4
402: days_per_year, org_information5 hours_per_year

Line 403: FROM hr_organization_information

399: ) IS
400: SELECT org_information2 weekly_working_hours, org_information3 daily_working_hours,
401: org_information4
402: days_per_year, org_information5 hours_per_year
403: FROM hr_organization_information
404: WHERE organization_id = p_legal_employer_id
405: AND org_information_context = 'SE_STD_WORK_DETAILS'
406: AND org_information1 = p_year;
407: