APPS.PN_CREATE_ACC dependencies on GL_SETS_OF_BOOKS

Line 1097: l_func_curr_code gl_sets_of_books.currency_code%TYPE;

1093: l_total_rev_percent NUMBER := 0;
1094: l_diff_amt NUMBER := 0;
1095: l_set_of_books_id NUMBER := TO_NUMBER(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID'
1096: ,pn_mo_cache_utils.get_current_org_id));
1097: l_func_curr_code gl_sets_of_books.currency_code%TYPE;
1098: l_conv_rate_type pn_currencies.conversion_type%TYPE;
1099: v_pn_EVENT_TYPE_CODE pn_payment_terms.EVENT_TYPE_CODE%TYPE;
1100: l_header_ID PN_AE_HEADERS.AE_HEADER_ID%TYPE;
1101: l_LINE_ID PN_AE_LINES.AE_LINE_ID%TYPE;

Line 1123: FROM gl_sets_of_books

1119: v_pn_lease_num PN_LEASES.lease_num%TYPE; --Bug#5739873
1120:
1121: CURSOR get_func_curr_code(p_set_of_books_id IN NUMBER) IS
1122: SELECT currency_code ,chart_of_accounts_id
1123: FROM gl_sets_of_books
1124: WHERE set_of_books_id = p_set_of_books_id;
1125:
1126: CURSOR get_acnt_info(p_term_id NUMBER) IS
1127: SELECT account_id,

Line 1850: l_func_curr_code gl_sets_of_books.currency_code%TYPE;

1846: l_total_exp_percent number := 0;
1847: l_diff_amt number := 0;
1848: l_set_of_books_id NUMBER := TO_NUMBER(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
1849: pn_mo_cache_utils.get_current_org_id));
1850: l_func_curr_code gl_sets_of_books.currency_code%TYPE;
1851: l_conv_rate_type pn_currencies.conversion_type%TYPE;
1852: v_pn_EVENT_TYPE_CODE pn_payment_terms.EVENT_TYPE_CODE%type;
1853: l_header_ID PN_AE_HEADERS.AE_HEADER_ID%type;
1854: l_LINE_ID PN_AE_LINES.AE_LINE_ID%type;

Line 1876: FROM gl_sets_of_books

1872: v_pn_lease_num PN_LEASES.lease_num%TYPE; --Bug#5739873
1873:
1874: CURSOR get_func_curr_code(p_set_of_books_id IN NUMBER) IS
1875: SELECT currency_code ,chart_of_accounts_id
1876: FROM gl_sets_of_books
1877: where set_of_books_id = p_set_of_books_id;
1878:
1879: CURSOR get_acnt_info(p_term_id NUMBER) IS
1880: SELECT account_id,