DBA Data[Home] [Help]

APPS.PAY_NL_NSI_PROCESS dependencies on HR_ORGANIZATION_UNITS

Line 175: FROM hr_organization_units hr_org

171: ,hr_loc.loc_information15 House_Num_Add
172: ,hr_loc.region_1 street_name
173: ,pay_nl_general.get_postal_code(hr_loc.postal_code) postal_code
174: ,hr_general.decode_lookup('HR_NL_CITY', hr_loc.town_or_city) city
175: FROM hr_organization_units hr_org
176: ,hr_locations hr_loc
177: WHERE hr_org.organization_id = p_organization_id
178: AND hr_org.location_id = hr_loc.location_id (+);
179: v_csr_get_address csr_get_address%ROWTYPE;

Line 850: l_Employer_ID hr_organization_units.organization_id%TYPE;

846: l_action_info_id pay_action_information.action_information_id%TYPE;
847: l_ovn pay_action_information.object_version_number%TYPE;
848:
849: l_effective_date DATE;
850: l_Employer_ID hr_organization_units.organization_id%TYPE;
851: l_Person_ID per_all_assignments_f.person_id%TYPE;
852: l_Assignment_ID per_all_assignments_f.assignment_id%TYPE;
853: l_Prev_Person_ID per_all_assignments_f.person_id%TYPE;
854: l_Prev_Assignment_ID per_all_assignments_f.assignment_id%TYPE;