APPS.AP_INVOICE_DISTRIBUTIONS_PKG dependencies on AP_SUPPLIERS

Line 1361: ap_suppliers PV,

1357: AI.attribute15,
1358: gsob.chart_of_accounts_id
1359: FROM ap_invoice_distributions AID,
1360: ap_invoices AI,
1361: ap_suppliers PV,
1362: po_distributions PD,
1363: ap_system_parameters ap,
1364: gl_sets_of_books gsob
1365: WHERE AI.invoice_id = X_invoice_id

Line 3822: l_employee_id AP_SUPPLIERS.EMPLOYEE_ID%TYPE;

3818: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;
3819: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;
3820: l_assets_tracking_flag
3821: AP_INVOICE_DISTRIBUTIONS.ASSETS_TRACKING_FLAG%TYPE;
3822: l_employee_id AP_SUPPLIERS.EMPLOYEE_ID%TYPE;
3823: l_accounting_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
3824: l_open_gl_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
3825: l_open_period_name AP_INVOICE_LINES.PERIOD_NAME%TYPE;
3826: user_id NUMBER;

Line 4014: FROM ap_suppliers /* bUg 4718054 */

4010:
4011: BEGIN
4012: SELECT employee_id
4013: INTO l_employee_id
4014: FROM ap_suppliers /* bUg 4718054 */
4015: WHERE DECODE(SIGN(TO_DATE(TO_CHAR(START_DATE_ACTIVE,'DD-MM-YYYY'),
4016: 'DD-MM-YYYY') - TO_DATE(TO_CHAR(SYSDATE,'DD-MM-YYYY'),'DD-MM-YYYY')),
4017: 1, 'N', DECODE(SIGN(TO_DATE(TO_CHAR(END_DATE_ACTIVE ,'DD-MM-YYYY'),
4018: 'DD-MM-YYYY') - TO_DATE(TO_CHAR(SYSDATE,'DD-MM-YYYY'),'DD-MM-YYYY')),

Line 4802: l_employee_id AP_SUPPLIERS.EMPLOYEE_ID%TYPE;

4798: l_po_accrue_on_receipt_flag PO_DISTRIBUTIONS.ACCRUE_ON_RECEIPT_FLAG%TYPE;
4799: l_po_ccid PO_DISTRIBUTIONS.CODE_COMBINATION_ID%TYPE;
4800: l_dist_ccid AP_INVOICE_DISTRIBUTIONS.DIST_CODE_COMBINATION_ID%TYPE;
4801: l_dist_code_concat VARCHAR2(2000);
4802: l_employee_id AP_SUPPLIERS.EMPLOYEE_ID%TYPE;
4803: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;
4804: user_id NUMBER;
4805: l_msg_application VARCHAR2(25);
4806: l_msg_type VARCHAR2(25);

Line 4873: FROM ap_suppliers /* bUg 4718054 */

4869:
4870: BEGIN
4871: SELECT employee_id
4872: INTO l_employee_id
4873: FROM ap_suppliers /* bUg 4718054 */
4874: WHERE DECODE(SIGN(TO_DATE(TO_CHAR(START_DATE_ACTIVE,'DD-MM-YYYY'),
4875: 'DD-MM-YYYY') - TO_DATE(TO_CHAR(SYSDATE,'DD-MM-YYYY'),'DD-MM-YYYY')),
4876: 1, 'N', DECODE(SIGN(TO_DATE(TO_CHAR(END_DATE_ACTIVE ,'DD-MM-YYYY'),
4877: 'DD-MM-YYYY') - TO_DATE(TO_CHAR(SYSDATE,'DD-MM-YYYY'),'DD-MM-YYYY')),