DBA Data[Home] [Help]

APPS.PA_PAY_INTERFACE dependencies on PA_IMPLEMENTATIONS_ALL

Line 6158: FROM pa_implementations_all imp1, pa_implementations_all imp2

6154: AND ITEMS.expenditure_item_id = X_exp_item_id;
6155:
6156: SELECT imp1.set_of_books_id, imp2.set_of_books_id
6157: INTO l_sob_id, l_recvr_sob_id
6158: FROM pa_implementations_all imp1, pa_implementations_all imp2
6159: WHERE imp1.org_id = l_org_id
6160: AND imp2.org_id = l_recvr_org_id;
6161:
6162: IF l_sys_link_function not in ('VI','ER') THEN

Line 6438: l_acct_rate_type pa_implementations_all.DEFAULT_RATE_TYPE%type;

6434: P_ORIG_CURR_CODE IN VARCHAR,
6435: x_denom_orig_amount OUT NOCOPY NUMBER
6436: )
6437: IS
6438: l_acct_rate_type pa_implementations_all.DEFAULT_RATE_TYPE%type;
6439: l_acct_rate_date_code pa_implementations_all.DEFAULT_RATE_DATE_CODE%type;
6440: l_acct_exch_rate NUMBER DEFAULT NULL;
6441: l_err_code VARCHAR2(200) DEFAULT NULL;
6442: l_err_stage NUMBER;

Line 6439: l_acct_rate_date_code pa_implementations_all.DEFAULT_RATE_DATE_CODE%type;

6435: x_denom_orig_amount OUT NOCOPY NUMBER
6436: )
6437: IS
6438: l_acct_rate_type pa_implementations_all.DEFAULT_RATE_TYPE%type;
6439: l_acct_rate_date_code pa_implementations_all.DEFAULT_RATE_DATE_CODE%type;
6440: l_acct_exch_rate NUMBER DEFAULT NULL;
6441: l_err_code VARCHAR2(200) DEFAULT NULL;
6442: l_err_stage NUMBER;
6443: l_acct_currency_code VARCHAR2(15);