APPS.AP_INVOICE_DISTRIBUTIONS_PKG dependencies on AP_SUPPLIERS

Line 1445: ap_suppliers PV,

1441: AI.attribute15,
1442: gsob.chart_of_accounts_id
1443: FROM ap_invoice_distributions AID,
1444: ap_invoices AI,
1445: ap_suppliers PV,
1446: po_distributions PD,
1447: ap_system_parameters ap,
1448: gl_sets_of_books gsob
1449: WHERE AI.invoice_id = X_invoice_id

Line 3993: l_employee_id AP_SUPPLIERS.EMPLOYEE_ID%TYPE;

3989: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;
3990: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;
3991: l_assets_tracking_flag
3992: AP_INVOICE_DISTRIBUTIONS.ASSETS_TRACKING_FLAG%TYPE;
3993: l_employee_id AP_SUPPLIERS.EMPLOYEE_ID%TYPE;
3994: l_accounting_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
3995: l_open_gl_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
3996: l_open_period_name AP_INVOICE_LINES.PERIOD_NAME%TYPE;
3997: user_id NUMBER;

Line 4293: FROM ap_suppliers /* bUg 4718054 */

4289:
4290: BEGIN
4291: SELECT employee_id
4292: INTO l_employee_id
4293: FROM ap_suppliers /* bUg 4718054 */
4294: WHERE DECODE(SIGN(TO_DATE(TO_CHAR(START_DATE_ACTIVE,'DD-MM-YYYY'),
4295: 'DD-MM-YYYY') - TO_DATE(TO_CHAR(SYSDATE,'DD-MM-YYYY'),'DD-MM-YYYY')),
4296: 1, 'N', DECODE(SIGN(TO_DATE(TO_CHAR(END_DATE_ACTIVE ,'DD-MM-YYYY'),
4297: 'DD-MM-YYYY') - TO_DATE(TO_CHAR(SYSDATE,'DD-MM-YYYY'),'DD-MM-YYYY')),

Line 5238: l_employee_id AP_SUPPLIERS.EMPLOYEE_ID%TYPE;

5234: l_base_currency_code AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;
5235: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;
5236: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;
5237: l_assets_tracking_flag AP_INVOICE_DISTRIBUTIONS.ASSETS_TRACKING_FLAG%TYPE;
5238: l_employee_id AP_SUPPLIERS.EMPLOYEE_ID%TYPE;
5239: l_accounting_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
5240: l_open_gl_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
5241: l_open_period_name AP_INVOICE_LINES.PERIOD_NAME%TYPE;
5242: user_id NUMBER;

Line 6085: l_employee_id AP_SUPPLIERS.EMPLOYEE_ID%TYPE;

6081: l_po_accrue_on_receipt_flag PO_DISTRIBUTIONS.ACCRUE_ON_RECEIPT_FLAG%TYPE;
6082: l_po_ccid PO_DISTRIBUTIONS.CODE_COMBINATION_ID%TYPE;
6083: l_dist_ccid AP_INVOICE_DISTRIBUTIONS.DIST_CODE_COMBINATION_ID%TYPE;
6084: l_dist_code_concat VARCHAR2(2000);
6085: l_employee_id AP_SUPPLIERS.EMPLOYEE_ID%TYPE;
6086: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;
6087: user_id NUMBER;
6088: l_msg_application VARCHAR2(25);
6089: l_msg_type VARCHAR2(25);

Line 6157: FROM ap_suppliers /* bUg 4718054 */

6153:
6154: BEGIN
6155: SELECT employee_id
6156: INTO l_employee_id
6157: FROM ap_suppliers /* bUg 4718054 */
6158: WHERE DECODE(SIGN(TO_DATE(TO_CHAR(START_DATE_ACTIVE,'DD-MM-YYYY'),
6159: 'DD-MM-YYYY') - TO_DATE(TO_CHAR(SYSDATE,'DD-MM-YYYY'),'DD-MM-YYYY')),
6160: 1, 'N', DECODE(SIGN(TO_DATE(TO_CHAR(END_DATE_ACTIVE ,'DD-MM-YYYY'),
6161: 'DD-MM-YYYY') - TO_DATE(TO_CHAR(SYSDATE,'DD-MM-YYYY'),'DD-MM-YYYY')),