APPS.LNS_DISTRIBUTIONS_PUB dependencies on LNS_DEFAULT_DISTRIBS

Line 775: || Source Tables: lns_default_distribs

771: || 'X' to exclude loan_clearing
772: ||
773: || Return value: x_distribution_tbl distribution table set to write to database
774: ||
775: || Source Tables: lns_default_distribs
776: ||
777: || Target Tables: NA
778: ||
779: || KNOWN ISSUES

Line 865: from lns_default_distribs

861:
862: cursor c_num_receivables(p_loan_class varchar2, p_loan_type_id number)
863: is
864: select count(1)
865: from lns_default_distribs
866: where loan_class = p_loan_class
867: AND loan_type_id = p_loan_type_id
868: and account_name = 'LOAN_RECEIVABLE'
869: and distribution_type = 'ORIGINATION'

Line 875: from lns_default_distribs

871:
872: cursor c_num_payables(p_loan_class varchar2, p_loan_type_id number)
873: is
874: select count(1)
875: from lns_default_distribs
876: where loan_class = p_loan_class
877: AND loan_type_id = p_loan_type_id
878: and account_name = 'LOAN_PAYABLE'
879: and distribution_type = 'FUNDING'

Line 939: -- of working for all organzations by replacing lns_default_distribs_all

935: -- now see if any default distributions exist for this loan
936: -- 2-24-2005 raverma -- add loan_payable IF loan_class = DIRECT OR
937: -- loan is not MFAR
938: -- Bug#5295575 Modified the query to work for an organization instead
939: -- of working for all organzations by replacing lns_default_distribs_all
940: -- with lns_default_distribs table
941:
942:
943: Begin

Line 940: -- with lns_default_distribs table

936: -- 2-24-2005 raverma -- add loan_payable IF loan_class = DIRECT OR
937: -- loan is not MFAR
938: -- Bug#5295575 Modified the query to work for an organization instead
939: -- of working for all organzations by replacing lns_default_distribs_all
940: -- with lns_default_distribs table
941:
942:
943: Begin
944: vPLSQL := 'SELECT d.line_type ' ||

Line 950: 'FROM lns_default_distribs d ' ||

946: ' ,d.code_combination_id ' ||
947: ' ,d.account_type ' ||
948: ' ,d.distribution_percent ' ||
949: ' ,d.distribution_type ' ||
950: 'FROM lns_default_distribs d ' ||
951: 'WHERE ((d.loan_class = :p_loan_class_code AND d.loan_type_id = :p_loan_type_id) ) ' ||
952: ' AND account_name IN (''PRINCIPAL_RECEIVABLE'', ''INTEREST_RECEIVABLE'', ''INTEREST_INCOME'' ';
953:
954: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'include receivabvles ' || p_include_loan_receivables);

Line 1257: from lns_default_distribs_all d

1253:
1254: -- this is cursor is for reading configuration for multi-fund swap natural account
1255: cursor c_mfar_nat_acct (p_loan_id number) is
1256: select MFAR_NATURAL_ACCOUNT_REC
1257: from lns_default_distribs_all d
1258: ,lns_loan_headers_all h
1259: where account_name = 'MFAR_FUND_ACCOUNT_CHANGE'
1260: and h.loan_id = p_loan_id
1261: and h.loan_class_code = d.loan_class

Line 1359: -- get the replacement accounts from lns_default_distribs

1355: for n in 1..l_num_segments loop
1356: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'seg#' || n || ' = ' || l_original_segments(n));
1357: end loop;
1358:
1359: -- get the replacement accounts from lns_default_distribs
1360: FOR n IN 1..l_num_segments LOOP
1361: IF (n = p_swap_segment_number) THEN
1362: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'found the account to swap = ' || l_original_segments(n));
1363: l_new_segments(n) := p_swap_segment_value;

Line 1443: from lns_default_distribs d

1439:
1440: -- gets the swap natural account value for LOAN_RECEIVABLE
1441: cursor c_mfar_nat_acct (p_loan_id number) is
1442: select MFAR_NATURAL_ACCOUNT_REC
1443: from lns_default_distribs d
1444: ,lns_loan_headers h
1445: where account_name = 'MFAR_FUND_ACCOUNT_CHANGE'
1446: and h.loan_id = p_loan_id
1447: and h.loan_class_code = d.loan_class

Line 1578: from lns_default_distribs

1574: ,distribution_type
1575: ,FEE_ID
1576: ,ORG_ID
1577: ,MFAR_NATURAL_ACCOUNT_REC
1578: from lns_default_distribs
1579: where loan_class = p_loan_class
1580: and loan_type_id = p_loan_type_id
1581: and account_type = p_acct_type
1582: and account_name = p_acct_name