DBA Data[Home] [Help]

APPS.AP_APXVDTIN_XMLP_PKG dependencies on AP_LOOKUP_CODES

Line 15: FROM_ATTENTION_LINE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

11: FROM_STATE HR_LOCATIONS.REGION_3%TYPE;
12: FROM_ZIP HR_LOCATIONS.POSTAL_CODE%TYPE;
13: LOCATION_ID HR_LOCATIONS.LOCATION_ID%TYPE;
14: DISP_RETURN_DATE VARCHAR2(30);
15: FROM_ATTENTION_LINE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
16: INIT_FAILURE EXCEPTION;
17: BEGIN
18: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
19: /*SRW.USER_EXIT('FND SRWINIT')*/NULL;

Line 97: AP_LOOKUP_CODES APL

93: INTO FROM_ADDRESS_LINE1,FROM_ADDRESS_LINE2,FROM_ADDRESS_LINE3,FROM_ADDRESS_LINE4,FROM_CITY,FROM_STATE,FROM_ZIP,LOCATION_ID,DISP_RETURN_DATE,FROM_ATTENTION_LINE
94: FROM
95: HR_LOCATIONS L,
96: AP_REPORTING_ENTITIES R,
97: AP_LOOKUP_CODES APL
98: WHERE L.LOCATION_ID = R.LOCATION_ID
99: AND R.TAX_ENTITY_ID = P_TAX_ENTITY_ID
100: AND APL.LOOKUP_CODE = P_ATTENTION_LINE
101: AND APL.LOOKUP_TYPE = 'ATTENTION';