DBA Data[Home] [Help]

APPS.LNS_DISTRIBUTIONS_PUB dependencies on LNS_DEFAULT_DISTRIBS_ALL

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

1169: -- now see if any default distributions exist for this loan
1170: -- 2-24-2005 raverma -- add loan_payable IF loan_class = DIRECT OR
1171: -- loan is not MFAR
1172: -- Bug#5295575 Modified the query to work for an organization instead
1173: -- of working for all organzations by replacing lns_default_distribs_all
1174: -- with lns_default_distribs table
1175:
1176:
1177: Begin

Line 1587: from lns_default_distribs_all d

1583:
1584: -- this is cursor is for reading configuration for multi-fund swap natural account
1585: cursor c_mfar_nat_acct (p_loan_id number) is
1586: select MFAR_NATURAL_ACCOUNT_REC
1587: from lns_default_distribs_all d
1588: ,lns_loan_headers_all h
1589: where account_name = 'MFAR_FUND_ACCOUNT_CHANGE'
1590: and h.loan_id = p_loan_id
1591: and h.loan_class_code = d.loan_class