APPS.LNS_DISTRIBUTIONS_PUB dependencies on LNS_LOAN_HEADERS_ALL

Line 844: from lns_loan_headers_all h

840: is
841: select h.loan_class_code
842: ,t.loan_type_id
843: ,h.funded_amount
844: from lns_loan_headers_all h
845: ,lns_loan_types t
846: where h.loan_id = p_loan_id
847: and h.loan_type_id = t.loan_type_id;
848:

Line 854: from lns_loan_headers_all h

850: is
851: select h.loan_class_code
852: ,t.loan_type_id
853: ,d.header_amount
854: from lns_loan_headers_all h
855: ,lns_loan_types t
856: ,lns_disb_headers d
857: where h.loan_id = p_loan_id
858: and h.loan_type_id = t.loan_type_id

Line 1126: from lns_loan_headers_all h

1122:
1123: cursor c_loan_info(p_loan_id number) is
1124: select h.loan_class_code
1125: ,h.loan_type_id
1126: from lns_loan_headers_all h
1127: where h.loan_id = p_loan_id;
1128:
1129: begin
1130: l_api_name := 'create_event';

Line 1258: ,lns_loan_headers_all h

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
1262: and h.loan_type_id = d.loan_type_id

Line 2473: from lns_loan_headers_all

2469: l_api_name varchar2(30);
2470:
2471: cursor c_loan_class(p_loan_id number) is
2472: select loan_class_code
2473: from lns_loan_headers_all
2474: where loan_id = p_loan_id;
2475:
2476: begin
2477:

Line 3055: lns_loan_headers_all

3051: cursor c_subsidy_rate (p_loan_id number) is
3052: SELECT
3053: (subsidy_rate/100)
3054: FROM
3055: lns_loan_headers_all
3056: WHERE
3057: loan_id = p_loan_id;
3058:
3059:

Line 3225: || Source Tables: LNS_DEFAULT_DISTRIBUTIONS, lns_loan_headers_all

3221: || Parameter: p_loan_id => loan to default
3222: ||
3223: || Return value: Standard S = Success E = Error U = Unexpected
3224: ||
3225: || Source Tables: LNS_DEFAULT_DISTRIBUTIONS, lns_loan_headers_all
3226: ||
3227: || Target Tables: LNS_DISTRIBUTIONS
3228: ||
3229: || KNOWN ISSUES

Line 3404: from lns_loan_headers_all h

3400: select h.loan_class_code
3401: ,t.loan_type_id
3402: ,h.funded_amount
3403: ,h.legal_entity_id
3404: from lns_loan_headers_all h
3405: ,lns_loan_types t
3406: where h.loan_id = p_loan_id
3407: and h.loan_type_id = t.loan_type_id;
3408: