APPS.AP_INVOICE_LINES_PKG dependencies on AP_SUPPLIERS

Line 87: l_employee_id AP_SUPPLIERS.EMPLOYEE_ID%TYPE;

83: ORDER BY distribution_set_line_number;
84:
85:
86: l_pa_allows_overrides VARCHAR2(1) := 'N';
87: l_employee_id AP_SUPPLIERS.EMPLOYEE_ID%TYPE;
88: user_id NUMBER;
89: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;
90: l_dset_line_ccid
91: AP_DISTRIBUTION_SET_LINES.DIST_CODE_COMBINATION_ID%TYPE;

Line 382: FROM ap_suppliers /* Bug 4718054 */

378: FND_PROFILE.VALUE('PA_ALLOW_FLEXBUILDER_OVERRIDES');
379: BEGIN
380: SELECT employee_id
381: INTO l_employee_id
382: FROM ap_suppliers /* Bug 4718054 */
383: WHERE DECODE(SIGN(TO_DATE(TO_CHAR(START_DATE_ACTIVE,'DD-MM-YYYY'),
384: 'DD-MM-YYYY') - TO_DATE(TO_CHAR(SYSDATE,'DD-MM-YYYY'),'DD-MM-YYYY')),
385: 1, 'N', DECODE(SIGN(TO_DATE(TO_CHAR(END_DATE_ACTIVE ,'DD-MM-YYYY'),
386: 'DD-MM-YYYY') - TO_DATE(TO_CHAR(SYSDATE,'DD-MM-YYYY'),'DD-MM-YYYY')),