APPS.PA_PAY_INTERFACE dependencies on PA_IMPLEMENTATIONS

Line 394: -- SELECT org_id INTO G_ORG_ID FROM pa_implementations;

390: write_log (LOG, 'P_EMP_ORG_ID -> ' || P_EMP_ORG_ID);
391: write_log (LOG, 'P_PERSON_ID -> ' || P_PERSON_ID);
392:
393:
394: -- SELECT org_id INTO G_ORG_ID FROM pa_implementations;
395: SELECT sysdate INTO G_RUN_DATE FROM dual;
396:
397: G_ORG_ID := FND_GLOBAL.ORG_ID;
398: G_USER_ID :=FND_GLOBAL.USER_ID;

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 6408: FROM pa_implementations ;

6404: DEFAULT_RATE_DATE_CODE
6405: INTO
6406: X_ACCT_RATE_TYPE,
6407: X_ACCT_RATE_DATE_CODE
6408: FROM pa_implementations ;
6409:
6410: EXCEPTION
6411: WHEN NO_DATA_FOUND THEN
6412: X_ACCT_RATE_TYPE := NULL;

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);