APPS.PAY_NO_EOY_ARCHIVE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 845: FROM hr_all_organization_units org

841: ,loc.address_line_3
842: ,loc.postal_code postcode
843: ,UPPER(SUBSTR(hr_general.decode_lookup('NO_POSTAL_CODE', loc.postal_code)
844: ,INSTR(hr_general.decode_lookup('NO_POSTAL_CODE', loc.postal_code), ' ') + 1)) postoffice
845: FROM hr_all_organization_units org
846: ,hr_locations_all loc
847: WHERE org.organization_id = p_organization_id
848: AND loc.location_id (+) = org.location_id;
849: --

Line 959: FROM hr_all_organization_units org

955: ,org.name
956: ,hoi2.org_information1 organization_number
957: ,TO_NUMBER(hoi2.org_information5) tax_office_id
958: ,hoi2.org_information2 tax_municipality
959: FROM hr_all_organization_units org
960: ,hr_organization_information hoi1
961: ,hr_organization_information hoi2
962: WHERE p_legal_employer_id IS NULL
963: AND org.business_group_id = p_business_group_id

Line 975: FROM hr_all_organization_units org

971: ,org.name
972: ,hoi1.org_information1 organization_number
973: ,TO_NUMBER(hoi1.org_information5) tax_office_id
974: ,hoi1.org_information2 tax_municipality
975: FROM hr_all_organization_units org
976: ,hr_organization_information hoi1
977: WHERE p_legal_employer_id IS NOT NULL
978: AND org.organization_id = p_legal_employer_id
979: AND hoi1.organization_id (+) = org.organization_id

Line 1108: ,hr_all_organization_units org2

1104: ,ff_contexts ctx1
1105: ,ff_contexts ctx2
1106: ,hr_lookups lu
1107: ,hr_organization_information orginf1
1108: ,hr_all_organization_units org2
1109: ,hr_organization_information orginf2
1110: ,pay_user_tables t
1111: ,pay_user_rows_f r
1112: WHERE ppa.business_group_id = p_business_group_id

Line 1162: l_le_name hr_all_organization_units.name%TYPE;

1158: l_asg_info_dfn VARCHAR2(61);
1159: l_le_si_count NUMBER := 0;
1160: l_le_si_bal_table t_le_si_bal_table;
1161: l_bal_value NUMBER := 0;
1162: l_le_name hr_all_organization_units.name%TYPE;
1163: l_le_addr1 hr_locations_all.address_line_1%TYPE;
1164: l_le_addr2 hr_locations_all.address_line_2%TYPE;
1165: l_le_addr3 hr_locations_all.address_line_3%TYPE;
1166: l_le_postcode hr_locations_all.postal_code%TYPE;

Line 1168: l_to_name hr_all_organization_units.name%TYPE;

1164: l_le_addr2 hr_locations_all.address_line_2%TYPE;
1165: l_le_addr3 hr_locations_all.address_line_3%TYPE;
1166: l_le_postcode hr_locations_all.postal_code%TYPE;
1167: l_le_postoffice VARCHAR2(100);
1168: l_to_name hr_all_organization_units.name%TYPE;
1169: l_to_addr1 hr_locations_all.address_line_1%TYPE;
1170: l_to_addr2 hr_locations_all.address_line_2%TYPE;
1171: l_to_addr3 hr_locations_all.address_line_3%TYPE;
1172: l_to_postcode hr_locations_all.postal_code%TYPE;