APPS.LNS_DISTRIBUTIONS_PUB dependencies on LNS_SYSTEM_OPTIONS

Line 1239: || Source Tables: lns_system_options

1235: || PARAMETERS p_loan_id = loan_id
1236: ||
1237: || Return value: new swap segment value
1238: ||
1239: || Source Tables: lns_system_options
1240: ||
1241: || Target Tables: NA
1242: ||
1243: || KNOWN ISSUES

Line 1891: || Source Tables: LNS_SYSTEM_OPTIONS, GL_SETS_OF_BOOKS

1887: || ,SHORT_NAME VARCHAR2(20)
1888: || ,CHART_OF_ACCOUNTS_ID NUMBER(15)
1889: || ,PERIOD_SET_NAME VARCHAR2(15));
1890: ||
1891: || Source Tables: LNS_SYSTEM_OPTIONS, GL_SETS_OF_BOOKS
1892: ||
1893: || Target Tables: NA
1894: ||
1895: || KNOWN ISSUES

Line 1916: FROM lns_system_options so,

1912: ,sb.chart_of_accounts_id
1913: ,sb.period_set_name
1914: ,sb.currency_code
1915: ,fndc.precision
1916: FROM lns_system_options so,
1917: gl_ledgers sb,
1918: fnd_currencies fndc
1919: WHERE sb.ledger_id = so.set_of_books_id
1920: and sb.currency_code = fndc.currency_code;

Line 2248: FROM lns_system_options so,

2244: and lnd.distribution_id = p_distribution_id;
2245:
2246: cursor c_currency2 is
2247: SELECT sb.currency_code
2248: FROM lns_system_options so,
2249: gl_sets_of_books sb
2250: WHERE sb.set_of_books_id = so.set_of_books_id;
2251:
2252: begin

Line 2292: | lns_system_options lso

2288: | Return value: value_set_id
2289: |
2290: | Source Tables: fnd_id_flex_segments s, fnd_segment_attribute_values sav,
2291: | fnd_segment_attribute_types sat
2292: | lns_system_options lso
2293: | gl_sets_of_books gl
2294: |
2295: | Target Tables: NA
2296: |

Line 2319: , lns_system_options lso

2315: SELECT s.segment_num
2316: FROM fnd_id_flex_segments s
2317: , fnd_segment_attribute_values sav
2318: , fnd_segment_attribute_types sat
2319: , lns_system_options lso
2320: , gl_ledgers gl
2321: WHERE s.application_id = p_application_id
2322: and lso.set_of_books_id = gl.ledger_id
2323: AND s.id_flex_code = p_flex_code

Line 2364: | lns_system_options lso

2360: | Return value: value_set_id
2361: |
2362: | Source Tables: fnd_id_flex_segments s, fnd_segment_attribute_values sav,
2363: | fnd_segment_attribute_types sat
2364: | lns_system_options lso
2365: | gl_sets_of_books gl
2366: |
2367: | Target Tables: NA
2368: |

Line 2388: ,lns_system_options lso

2384: SELECT s.flex_value_set_id
2385: FROM fnd_id_flex_segments s
2386: ,fnd_segment_attribute_values sav
2387: ,fnd_segment_attribute_types sat
2388: ,lns_system_options lso
2389: ,gl_ledgers gl
2390: WHERE s.application_id = 101
2391: and lso.set_of_books_id = gl.ledger_id
2392: AND s.id_flex_code = 'GL#'