DBA Data[Home] [Help]

APPS.PAY_SE_TRNA_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 247: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE

243: l_previous_end_date DATE;
244:
245: -- Archiving the data , as this will fire once
246: CURSOR csr_legal_employer_details (
247: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE
248: ) IS
249: SELECT o1.NAME legal_employer_name, hoi2.org_information2 org_number, hoi1.organization_id legal_id
250: FROM hr_organization_units o1, hr_organization_information hoi1, hr_organization_information hoi2
251: WHERE o1.business_group_id = g_business_group_id

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

246: CURSOR csr_legal_employer_details (
247: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE
248: ) IS
249: SELECT o1.NAME legal_employer_name, hoi2.org_information2 org_number, hoi1.organization_id legal_id
250: FROM hr_organization_units o1, hr_organization_information hoi1, hr_organization_information hoi2
251: WHERE o1.business_group_id = g_business_group_id
252: AND hoi1.organization_id = o1.organization_id
253: AND hoi1.organization_id = nvl (csr_v_legal_employer_id, hoi1.organization_id)
254: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 378: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE

374: p_end_person IN NUMBER,
375: p_chunk IN NUMBER
376: ) IS
377: CURSOR csr_legal_employer_details (
378: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE
379: ) IS
380: SELECT o1.NAME legal_employer_name, hoi2.org_information2 org_number, hoi1.organization_id legal_id
381: FROM hr_organization_units o1, hr_organization_information hoi1, hr_organization_information hoi2
382: WHERE o1.business_group_id = g_business_group_id

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

377: CURSOR csr_legal_employer_details (
378: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE
379: ) IS
380: SELECT o1.NAME legal_employer_name, hoi2.org_information2 org_number, hoi1.organization_id legal_id
381: FROM hr_organization_units o1, hr_organization_information hoi1, hr_organization_information hoi2
382: WHERE o1.business_group_id = g_business_group_id
383: AND hoi1.organization_id = o1.organization_id
384: AND hoi1.organization_id = nvl (csr_v_legal_employer_id, hoi1.organization_id)
385: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 391: p_legal_employer_id hr_organization_information.organization_id%TYPE

387: AND o1.organization_id = hoi2.organization_id
388: AND hoi2.org_information_context = 'SE_LEGAL_EMPLOYER_DETAILS';
389:
390: CURSOR csr_person_assignments (
391: p_legal_employer_id hr_organization_information.organization_id%TYPE
392: ) IS
393: SELECT papf.person_id, paaf.assignment_id, papf.full_name, papf.national_identifier, paaf.assignment_number,
394: paaf.employment_category, hsck.segment15 div_code, hsck.segment14 area_code
395: FROM per_all_assignments_f paaf,

Line 398: hr_organization_information hoi,

394: paaf.employment_category, hsck.segment15 div_code, hsck.segment14 area_code
395: FROM per_all_assignments_f paaf,
396: hr_soft_coding_keyflex hsck,
397: hr_organization_units hou,
398: hr_organization_information hoi,
399: per_all_people_f papf
400: WHERE papf.person_id BETWEEN p_start_person AND p_end_person
401: AND g_report_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
402: AND paaf.effective_start_date BETWEEN papf.effective_start_date AND papf.effective_end_date