DBA Data[Home] [Help]

APPS.PAY_PAYAUSOE_XMLP_PKG dependencies on HR_LOCATIONS

Line 197: V_ADDRESS_LINE_1 HR_LOCATIONS.ADDRESS_LINE_1%TYPE;

193: ,LOCATION_ID IN NUMBER
194: ,ASSIGNMENT_ID IN NUMBER
195: ,ASSIGNMENT_ACTION_ID IN NUMBER
196: ,DATE_EARNED IN DATE) RETURN NUMBER IS
197: V_ADDRESS_LINE_1 HR_LOCATIONS.ADDRESS_LINE_1%TYPE;
198: V_ADDRESS_LINE_2 HR_LOCATIONS.ADDRESS_LINE_2%TYPE;
199: V_ADDRESS_LINE_3 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;
200: V_TOWN_CITY HR_LOCATIONS.TOWN_OR_CITY%TYPE;
201: V_POSTAL_CODE HR_LOCATIONS.POSTAL_CODE%TYPE;

Line 198: V_ADDRESS_LINE_2 HR_LOCATIONS.ADDRESS_LINE_2%TYPE;

194: ,ASSIGNMENT_ID IN NUMBER
195: ,ASSIGNMENT_ACTION_ID IN NUMBER
196: ,DATE_EARNED IN DATE) RETURN NUMBER IS
197: V_ADDRESS_LINE_1 HR_LOCATIONS.ADDRESS_LINE_1%TYPE;
198: V_ADDRESS_LINE_2 HR_LOCATIONS.ADDRESS_LINE_2%TYPE;
199: V_ADDRESS_LINE_3 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;
200: V_TOWN_CITY HR_LOCATIONS.TOWN_OR_CITY%TYPE;
201: V_POSTAL_CODE HR_LOCATIONS.POSTAL_CODE%TYPE;
202: V_COUNTRY FND_TERRITORIES_TL.TERRITORY_SHORT_NAME%TYPE;

Line 199: V_ADDRESS_LINE_3 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;

195: ,ASSIGNMENT_ACTION_ID IN NUMBER
196: ,DATE_EARNED IN DATE) RETURN NUMBER IS
197: V_ADDRESS_LINE_1 HR_LOCATIONS.ADDRESS_LINE_1%TYPE;
198: V_ADDRESS_LINE_2 HR_LOCATIONS.ADDRESS_LINE_2%TYPE;
199: V_ADDRESS_LINE_3 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;
200: V_TOWN_CITY HR_LOCATIONS.TOWN_OR_CITY%TYPE;
201: V_POSTAL_CODE HR_LOCATIONS.POSTAL_CODE%TYPE;
202: V_COUNTRY FND_TERRITORIES_TL.TERRITORY_SHORT_NAME%TYPE;
203: V_SUPER_THIS_PAY NUMBER;

Line 200: V_TOWN_CITY HR_LOCATIONS.TOWN_OR_CITY%TYPE;

196: ,DATE_EARNED IN DATE) RETURN NUMBER IS
197: V_ADDRESS_LINE_1 HR_LOCATIONS.ADDRESS_LINE_1%TYPE;
198: V_ADDRESS_LINE_2 HR_LOCATIONS.ADDRESS_LINE_2%TYPE;
199: V_ADDRESS_LINE_3 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;
200: V_TOWN_CITY HR_LOCATIONS.TOWN_OR_CITY%TYPE;
201: V_POSTAL_CODE HR_LOCATIONS.POSTAL_CODE%TYPE;
202: V_COUNTRY FND_TERRITORIES_TL.TERRITORY_SHORT_NAME%TYPE;
203: V_SUPER_THIS_PAY NUMBER;
204: V_SUPER_YTD NUMBER;

Line 201: V_POSTAL_CODE HR_LOCATIONS.POSTAL_CODE%TYPE;

197: V_ADDRESS_LINE_1 HR_LOCATIONS.ADDRESS_LINE_1%TYPE;
198: V_ADDRESS_LINE_2 HR_LOCATIONS.ADDRESS_LINE_2%TYPE;
199: V_ADDRESS_LINE_3 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;
200: V_TOWN_CITY HR_LOCATIONS.TOWN_OR_CITY%TYPE;
201: V_POSTAL_CODE HR_LOCATIONS.POSTAL_CODE%TYPE;
202: V_COUNTRY FND_TERRITORIES_TL.TERRITORY_SHORT_NAME%TYPE;
203: V_SUPER_THIS_PAY NUMBER;
204: V_SUPER_YTD NUMBER;
205: BEGIN