APPS.AP_INVOICE_LINES_PKG dependencies on AP_SUPPLIERS

Line 101: l_employee_id AP_SUPPLIERS.EMPLOYEE_ID%TYPE;

97: ORDER BY distribution_set_line_number;
98:
99:
100: l_pa_allows_overrides VARCHAR2(1) := 'N';
101: l_employee_id AP_SUPPLIERS.EMPLOYEE_ID%TYPE;
102: user_id NUMBER;
103: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;
104: l_dset_line_ccid
105: AP_DISTRIBUTION_SET_LINES.DIST_CODE_COMBINATION_ID%TYPE;

Line 411: FROM ap_suppliers /* Bug 4718054 */

407: FND_PROFILE.VALUE('PA_ALLOW_FLEXBUILDER_OVERRIDES');
408: BEGIN
409: SELECT employee_id
410: INTO l_employee_id
411: FROM ap_suppliers /* Bug 4718054 */
412: WHERE DECODE(SIGN(TO_DATE(TO_CHAR(START_DATE_ACTIVE,'DD-MM-YYYY'),
413: 'DD-MM-YYYY') - TO_DATE(TO_CHAR(SYSDATE,'DD-MM-YYYY'),'DD-MM-YYYY')),
414: 1, 'N', DECODE(SIGN(TO_DATE(TO_CHAR(END_DATE_ACTIVE ,'DD-MM-YYYY'),
415: 'DD-MM-YYYY') - TO_DATE(TO_CHAR(SYSDATE,'DD-MM-YYYY'),'DD-MM-YYYY')),