APPS.PAY_US_SIMULATION dependencies on HR_LOCATIONS_ALL

Line 61: hr_locations_all loc

57: CURSOR get_employer_name_phone ( cp_organization_id NUMBER)
58: IS
59: SELECT org.name,loc.telephone_number_1
60: FROM hr_all_organization_units org,
61: hr_locations_all loc
62: WHERE org.location_id=loc.location_id
63: AND org.organization_id = cp_organization_id;
64:
65: lv_procedure_name VARCHAR2(100) := '.add_custom_xml';

Line 83: lv_phone_number hr_locations_all.telephone_number_1%TYPE;

79: lv_employer_zip_code pay_action_information.action_information1%TYPE;
80: lv_employer_country pay_action_information.action_information1%TYPE;
81:
82: lv_employer_name hr_all_organization_units.name%TYPE;
83: lv_phone_number hr_locations_all.telephone_number_1%TYPE;
84:
85: ln_net_pay_ytd NUMBER;
86: ln_amount NUMBER;
87: