APPS.PAY_NL_NSI_PROCESS dependencies on HR_ORGANIZATION_INFORMATION

Line 194: FROM hr_organization_information hoi

190: ,hoi.org_information8 Sender_Rep_Name
191: ,hoi.org_information9 Sender_Reg_Number
192: ,hoi.org_information10 Employer_Rep_Name
193: ,hoi.org_information11 Employer_Reg_Number
194: FROM hr_organization_information hoi
195: WHERE hoi.org_information_context='NL_SIP'
196: AND hoi.organization_id = p_organization_id
197: AND hoi.org_information4 = p_si_provider_id
198: AND hoi.org_information3 IN('ZFW','ZW','WW','WAO','AMI')

Line 1854: from hr_organization_information hoi where hoi.org_information_context='NL_BG_INFO'

1850: per_organization_structures pos,
1851: per_org_structure_versions posv
1852: where pos.organization_structure_id = posv.organization_structure_id
1853: and to_char(pos.organization_structure_id) IN (select org_information1
1854: from hr_organization_information hoi where hoi.org_information_context='NL_BG_INFO'
1855: and hoi.organization_id=lp_business_group_id)
1856: and lp_process_date between posv.date_from and nvl(posv.date_to,hr_general.End_of_time);
1857: v_csr_org_hierarchy csr_org_hierarchy%ROWTYPE;
1858: -- Cursor to retrieve All Employee SI Records.

Line 1984: l_Registration_Number hr_organization_information.ORG_INFORMATION6%TYPE;

1980: l_Prev_Assignment_ID per_all_assignments_f.person_id%TYPE;
1981: l_Prev_SIProvider_ID per_all_assignments_f.person_id%TYPE;
1982:
1983: l_effective_date DATE;
1984: l_Registration_Number hr_organization_information.ORG_INFORMATION6%TYPE;
1985: l_Person_ID per_all_assignments_f.person_id%TYPE;
1986: l_Assignment_ID per_all_assignments_f.person_id%TYPE;
1987: l_NSI_Process_Date DATE;
1988: l_Hire_Date DATE;