APPS.PN_CREATE_ACC dependencies on GL_SETS_OF_BOOKS

Line 375: FROM gl_sets_of_books

371: WHERE payment_term_id = p_term_id;
372:
373: CURSOR get_func_curr_code(p_set_of_books_id IN NUMBER) IS
374: SELECT currency_code ,chart_of_accounts_id
375: FROM gl_sets_of_books
376: WHERE set_of_books_id = p_set_of_books_id;
377:
378:
379: l_amt NUMBER := 0;

Line 396: l_func_curr_code gl_sets_of_books.currency_code%TYPE;

392: l_acc_cnt NUMBER :=0;
393:
394: l_set_of_books_id NUMBER := TO_NUMBER(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
395: pn_mo_cache_utils.get_current_org_id));
396: l_func_curr_code gl_sets_of_books.currency_code%TYPE;
397: l_chart_of_id NUMBER;
398: l_conv_rate_type pn_currencies.conversion_type%TYPE;
399:
400: l_precision NUMBER := 2 ;

Line 1565: l_func_curr_code gl_sets_of_books.currency_code%TYPE;

1561: l_total_rev_percent NUMBER := 0;
1562: l_diff_amt NUMBER := 0;
1563: l_set_of_books_id NUMBER := TO_NUMBER(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID'
1564: ,pn_mo_cache_utils.get_current_org_id));
1565: l_func_curr_code gl_sets_of_books.currency_code%TYPE;
1566: l_conv_rate_type pn_currencies.conversion_type%TYPE;
1567: v_pn_EVENT_TYPE_CODE pn_payment_terms.EVENT_TYPE_CODE%TYPE;
1568: l_header_ID PN_AE_HEADERS.AE_HEADER_ID%TYPE;
1569: l_LINE_ID PN_AE_LINES.AE_LINE_ID%TYPE;

Line 1591: FROM gl_sets_of_books

1587: v_pn_lease_num PN_LEASES.lease_num%TYPE; --Bug#5739873
1588:
1589: CURSOR get_func_curr_code(p_set_of_books_id IN NUMBER) IS
1590: SELECT currency_code ,chart_of_accounts_id
1591: FROM gl_sets_of_books
1592: WHERE set_of_books_id = p_set_of_books_id;
1593:
1594: CURSOR get_acnt_info(p_term_id NUMBER) IS
1595: SELECT account_id,

Line 2318: l_func_curr_code gl_sets_of_books.currency_code%TYPE;

2314: l_total_exp_percent number := 0;
2315: l_diff_amt number := 0;
2316: l_set_of_books_id NUMBER := TO_NUMBER(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
2317: pn_mo_cache_utils.get_current_org_id));
2318: l_func_curr_code gl_sets_of_books.currency_code%TYPE;
2319: l_conv_rate_type pn_currencies.conversion_type%TYPE;
2320: v_pn_EVENT_TYPE_CODE pn_payment_terms.EVENT_TYPE_CODE%type;
2321: l_header_ID PN_AE_HEADERS.AE_HEADER_ID%type;
2322: l_LINE_ID PN_AE_LINES.AE_LINE_ID%type;

Line 2344: FROM gl_sets_of_books

2340: v_pn_lease_num PN_LEASES.lease_num%TYPE; --Bug#5739873
2341:
2342: CURSOR get_func_curr_code(p_set_of_books_id IN NUMBER) IS
2343: SELECT currency_code ,chart_of_accounts_id
2344: FROM gl_sets_of_books
2345: where set_of_books_id = p_set_of_books_id;
2346:
2347: CURSOR get_acnt_info(p_term_id NUMBER) IS
2348: SELECT account_id,