2493: || ,SHORT_NAME VARCHAR2(20)
2494: || ,CHART_OF_ACCOUNTS_ID NUMBER(15)
2495: || ,PERIOD_SET_NAME VARCHAR2(15));
2496: ||
2497: || Source Tables: LNS_SYSTEM_OPTIONS, GL_SETS_OF_BOOKS
2498: ||
2499: || Target Tables: NA
2500: ||
2501: || KNOWN ISSUES
2851:
2852: cursor c_currency2 is
2853: SELECT sb.currency_code
2854: FROM lns_system_options so,
2855: gl_sets_of_books sb
2856: WHERE sb.set_of_books_id = so.set_of_books_id;
2857:
2858: begin
2859: l_api_name := 'calculateDistAmount';
2895: |
2896: | Source Tables: fnd_id_flex_segments s, fnd_segment_attribute_values sav,
2897: | fnd_segment_attribute_types sat
2898: | lns_system_options lso
2899: | gl_sets_of_books gl
2900: |
2901: | Target Tables: NA
2902: |
2903: | KNOWN ISSUES
2967: |
2968: | Source Tables: fnd_id_flex_segments s, fnd_segment_attribute_values sav,
2969: | fnd_segment_attribute_types sat
2970: | lns_system_options lso
2971: | gl_sets_of_books gl
2972: |
2973: | Target Tables: NA
2974: |
2975: | KNOWN ISSUES
10466: x_return boolean;
10467:
10468: cursor C_COA_DETAILS is
10469: select chart_of_accounts_id
10470: from gl_sets_of_books gl_books
10471: where gl_books.set_of_books_id = (select set_of_books_id from lns_system_options);
10472:
10473: cursor C_LOAN_DETAILS(p_loan_id in number) is
10474: select org_id