APPS.PAY_NL_REM_REPORT dependencies on HR_ORGANIZATION_INFORMATION

Line 753: l_tax_ref_no hr_organization_information.org_information1%TYPE;

749:
750: /*******************************************************
751: Variables to Store Organization Details
752: ********************************************************/
753: l_tax_ref_no hr_organization_information.org_information1%TYPE;
754: l_hr_tax_unit hr_all_organization_units.organization_id%TYPE;
755: l_tax_reg_no hr_organization_information.org_information4%TYPE;
756: l_tax_rep_name hr_organization_information.org_information3%TYPE;
757: l_tax_reg_no1 VARCHAR2(14);

Line 755: l_tax_reg_no hr_organization_information.org_information4%TYPE;

751: Variables to Store Organization Details
752: ********************************************************/
753: l_tax_ref_no hr_organization_information.org_information1%TYPE;
754: l_hr_tax_unit hr_all_organization_units.organization_id%TYPE;
755: l_tax_reg_no hr_organization_information.org_information4%TYPE;
756: l_tax_rep_name hr_organization_information.org_information3%TYPE;
757: l_tax_reg_no1 VARCHAR2(14);
758: l_tax_org_id NUMBER;
759: l_bg_name VARCHAR2(100);

Line 756: l_tax_rep_name hr_organization_information.org_information3%TYPE;

752: ********************************************************/
753: l_tax_ref_no hr_organization_information.org_information1%TYPE;
754: l_hr_tax_unit hr_all_organization_units.organization_id%TYPE;
755: l_tax_reg_no hr_organization_information.org_information4%TYPE;
756: l_tax_rep_name hr_organization_information.org_information3%TYPE;
757: l_tax_reg_no1 VARCHAR2(14);
758: l_tax_org_id NUMBER;
759: l_bg_name VARCHAR2(100);
760: l_org_address VARCHAR2(3000);

Line 929: FROM hr_organization_information e

925: )
926: UNION
927: (
928: SELECT e.organization_id
929: FROM hr_organization_information e
930: WHERE e.organization_id IN
931: (
932: SELECT pose.organization_id_child employer
933: FROM per_org_structure_elements pose

Line 969: FROM hr_organization_information hoi

965: CURSOR csr_le_hr_mapping_chk IS
966: SELECT hoi.org_information1 tax_ref_no
967: ,hoi.org_information2 org_id
968: ,hoi.org_information3 tax_rep_name
969: FROM hr_organization_information hoi
970: ,hr_organization_information hoi1
971: WHERE hoi.org_information_context = 'NL_LE_TAX_DETAILS'
972: AND hoi.organization_id = hoi1.organization_id
973: AND hoi1.organization_id = l_tax_org_id

Line 970: ,hr_organization_information hoi1

966: SELECT hoi.org_information1 tax_ref_no
967: ,hoi.org_information2 org_id
968: ,hoi.org_information3 tax_rep_name
969: FROM hr_organization_information hoi
970: ,hr_organization_information hoi1
971: WHERE hoi.org_information_context = 'NL_LE_TAX_DETAILS'
972: AND hoi.organization_id = hoi1.organization_id
973: AND hoi1.organization_id = l_tax_org_id
974: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 984: ,hr_organization_information hoi

980: CURSOR csr_tax_reg_no(c_employer_id IN NUMBER,
981: c_business_group_id IN NUMBER) IS
982: SELECT hoi.org_information4 tax_reg_number
983: FROM hr_organization_units hou
984: ,hr_organization_information hoi
985: WHERE hoi.org_information_context = 'NL_ORG_INFORMATION'
986: AND hou.business_group_id = c_business_group_id
987: AND hou.organization_id = hoi.organization_id
988: AND hou.organization_id = c_employer_id;

Line 1046: FROM hr_organization_information e1

1042: AND pose1.organization_id_parent = c_tax_org_id
1043: AND pose1.organization_id_child NOT IN
1044: (
1045: SELECT DISTINCT e1.organization_id
1046: FROM hr_organization_information e1
1047: WHERE e1.organization_id = pose1.organization_id_child
1048: AND (
1049: (
1050: e1.org_information_context = 'NL_ORG_INFORMATION'