APPS.AP_APXBCRPT_XMLP_PKG dependencies on AP_LOOKUP_CODES

Line 78: LP_AP_AR_TAB := ', ap_lookup_codes alc ';

74: END IF;
75: /*SRW.MESSAGE('15'
76: ,'Setting Where Clause based on Application')*/NULL;
77: IF (H_APPLICATION_ID = 200) THEN
78: LP_AP_AR_TAB := ', ap_lookup_codes alc ';
79: LP_AP_AR_WHERE := ' and alc.lookup_type = ''TRANSFER_PRIORITY''' || ' and abc.transfer_priority = alc.lookup_code ';
80: ELSIF (H_APPLICATION_ID = 222) THEN
81: LP_AP_AR_TAB := ' ';
82: LP_AP_AR_WHERE := ' ';

Line 115: AP_LOOKUP_CODES

111: SELECT
112: DISPLAYED_FIELD
113: INTO L_TRANSFER_PRIORITY
114: FROM
115: AP_LOOKUP_CODES
116: WHERE LOOKUP_TYPE = 'TRANSFER_PRIORITY'
117: AND LOOKUP_CODE = C_TRANSFER_PRIORITY;
118: END IF;
119: RETURN (L_TRANSFER_PRIORITY);