APPS.PAY_NO_EOY_ARCHIVE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 938: FROM hr_all_organization_units org

934: ,loc.address_line_3
935: ,loc.postal_code postcode
936: ,UPPER(SUBSTR(hr_general.decode_lookup('NO_POSTAL_CODE', loc.postal_code)
937: ,INSTR(hr_general.decode_lookup('NO_POSTAL_CODE', loc.postal_code), ' ') + 1)) postoffice
938: FROM hr_all_organization_units org
939: ,hr_locations_all loc
940: WHERE org.organization_id = p_organization_id
941: AND loc.location_id (+) = org.location_id;
942: --

Line 1052: FROM hr_all_organization_units org

1048: ,org.name
1049: ,hoi2.org_information1 organization_number
1050: ,TO_NUMBER(hoi2.org_information5) tax_office_id
1051: ,hoi2.org_information2 tax_municipality
1052: FROM hr_all_organization_units org
1053: ,hr_organization_information hoi1
1054: ,hr_organization_information hoi2
1055: WHERE p_legal_employer_id IS NULL
1056: AND org.business_group_id = p_business_group_id

Line 1068: FROM hr_all_organization_units org

1064: ,org.name
1065: ,hoi1.org_information1 organization_number
1066: ,TO_NUMBER(hoi1.org_information5) tax_office_id
1067: ,hoi1.org_information2 tax_municipality
1068: FROM hr_all_organization_units org
1069: ,hr_organization_information hoi1
1070: WHERE p_legal_employer_id IS NOT NULL
1071: AND org.organization_id = p_legal_employer_id
1072: AND hoi1.organization_id (+) = org.organization_id

Line 1236: ,hr_all_organization_units org2

1232: ,ff_contexts ctx1
1233: ,ff_contexts ctx2
1234: ,hr_lookups lu
1235: ,hr_organization_information orginf1
1236: ,hr_all_organization_units org2
1237: ,hr_organization_information orginf2
1238: ,pay_user_tables t
1239: ,pay_user_rows_f r
1240: WHERE ppa.business_group_id = p_business_group_id

Line 1313: l_le_name hr_all_organization_units.name%TYPE;

1309: l_asg_info_dfn VARCHAR2(61);
1310: l_le_si_count NUMBER := 0;
1311: l_le_si_bal_table t_le_si_bal_table;
1312: l_bal_value NUMBER := 0;
1313: l_le_name hr_all_organization_units.name%TYPE;
1314: l_le_addr1 hr_locations_all.address_line_1%TYPE;
1315: l_le_addr2 hr_locations_all.address_line_2%TYPE;
1316: l_le_addr3 hr_locations_all.address_line_3%TYPE;
1317: l_le_postcode hr_locations_all.postal_code%TYPE;

Line 1319: l_to_name hr_all_organization_units.name%TYPE;

1315: l_le_addr2 hr_locations_all.address_line_2%TYPE;
1316: l_le_addr3 hr_locations_all.address_line_3%TYPE;
1317: l_le_postcode hr_locations_all.postal_code%TYPE;
1318: l_le_postoffice VARCHAR2(100);
1319: l_to_name hr_all_organization_units.name%TYPE;
1320: l_to_addr1 hr_locations_all.address_line_1%TYPE;
1321: l_to_addr2 hr_locations_all.address_line_2%TYPE;
1322: l_to_addr3 hr_locations_all.address_line_3%TYPE;
1323: l_to_postcode hr_locations_all.postal_code%TYPE;