DBA Data[Home] [Help]

APPS.PAY_NL_ANNUAL_SI_FILE dependencies on HR_ORGANIZATION_INFORMATION

Line 357: FROM hr_organization_information

353: CURSOR csr_sip_details(p_employer_id NUMBER , p_si_provider_id NUMBER) IS
354: SELECT org_information8 SRepName,org_information9 SRegNo,
355: org_information10 ERRepName,org_information11 ERRegNo,
356: DECODE(org_information3,'ZFW',1,'ZW',2,'WW',3,'WAO',4,'AMI',5,6) sort_order
357: FROM hr_organization_information
358: where organization_id = p_employer_id
359: and org_information_context = 'NL_SIP'
360: and org_information4 = p_si_provider_id
361: AND p_process_date between