DBA Data[Home] [Help]

APPS.PAY_NL_TAXOFFICE_FILE dependencies on HR_ORGANIZATION_INFORMATION

Line 492: from hr_organization_information

488: ,P_Tax_Reg_Number out nocopy varchar2) return number IS
489:
490: CURSOR csr_Sender_tax_Details IS
491: select ORG_INFORMATION3,ORG_INFORMATION4
492: from hr_organization_information
493: where ORG_INFORMATION_CONTEXT='NL_BG_INFO' and
494: organization_id=P_Business_Group_Id;
495:
496: CURSOR csr_tax_details IS

Line 498: from hr_organization_units hou,hr_organization_information hoi

494: organization_id=P_Business_Group_Id;
495:
496: CURSOR csr_tax_details IS
497: select hoi.ORG_INFORMATION14,hoi.ORG_INFORMATION4
498: from hr_organization_units hou,hr_organization_information hoi
499: where
500: hoi.org_information_context= 'NL_ORG_INFORMATION'
501: and hou.business_group_id=p_business_group_id
502: and hou.organization_id= hoi.organization_id