APPS.LNS_DISTRIBUTIONS_PUB dependencies on LNS_LOAN_HEADERS_ALL

Line 1051: from lns_loan_headers_all h

1047: select h.loan_class_code
1048: ,t.loan_type_id
1049: -- ,h.funded_amount
1050: ,h.requested_amount -- Bug#9755933
1051: from lns_loan_headers_all h
1052: ,lns_loan_types t
1053: where h.loan_id = p_loan_id
1054: and h.loan_type_id = t.loan_type_id;
1055:

Line 1061: from lns_loan_headers_all h

1057: is
1058: select h.loan_class_code
1059: ,t.loan_type_id
1060: ,d.header_amount
1061: from lns_loan_headers_all h
1062: ,lns_loan_types t
1063: ,lns_disb_headers d
1064: where h.loan_id = p_loan_id
1065: and h.loan_type_id = t.loan_type_id

Line 1074: from lns_loan_headers_all h

1070: is
1071: select h.loan_class_code
1072: ,t.loan_type_id
1073: ,ladj.adjustment_amount
1074: from lns_loan_headers_all h
1075: ,lns_loan_types t
1076: ,LNS_LOAN_AMOUNT_ADJS ladj
1077: where h.loan_id = p_loan_id
1078: and h.loan_type_id = t.loan_type_id

Line 1429: from lns_loan_headers_all h

1425:
1426: cursor c_loan_info(p_loan_id number) is
1427: select h.loan_class_code
1428: ,h.loan_type_id
1429: from lns_loan_headers_all h
1430: where h.loan_id = p_loan_id;
1431:
1432: begin
1433: l_api_name := 'create_event';

Line 1588: ,lns_loan_headers_all h

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

Line 3092: from lns_loan_headers_all

3088: l_api_name varchar2(30);
3089:
3090: cursor c_loan_class(p_loan_id number) is
3091: select loan_class_code, loan_status
3092: from lns_loan_headers_all
3093: where loan_id = p_loan_id;
3094:
3095: CURSOR c_get_prin_distr(C_LOAN_ID number) IS
3096: SELECT dist.distribution_id

Line 3816: lns_loan_headers_all

3812: cursor c_subsidy_rate (p_loan_id number) is
3813: SELECT
3814: (nvl(subsidy_rate, 0)/100)
3815: FROM
3816: lns_loan_headers_all
3817: WHERE
3818: loan_id = p_loan_id;
3819:
3820: cursor c_loan_adj(c_loan_id number) is

Line 4050: || Source Tables: LNS_DEFAULT_DISTRIBUTIONS, lns_loan_headers_all

4046: || Parameter: p_loan_id => loan to default
4047: ||
4048: || Return value: Standard S = Success E = Error U = Unexpected
4049: ||
4050: || Source Tables: LNS_DEFAULT_DISTRIBUTIONS, lns_loan_headers_all
4051: ||
4052: || Target Tables: LNS_DISTRIBUTIONS
4053: ||
4054: || KNOWN ISSUES

Line 4241: from lns_loan_headers_all h

4237: ,'PENDING', h.requested_amount
4238: ,h.funded_amount)
4239: ,h.legal_entity_id
4240: ,h.LOAN_STATUS
4241: from lns_loan_headers_all h
4242: ,lns_loan_types t
4243: where h.loan_id = p_loan_id
4244: and h.loan_type_id = t.loan_type_id;
4245:

Line 7292: || Source Tables: LNS_DISTRIBUTIONS, lns_loan_headers_all

7288: || Parameter: p_loan_id => loan to default
7289: ||
7290: || Return value: Standard S = Success E = Error U = Unexpected
7291: ||
7292: || Source Tables: LNS_DISTRIBUTIONS, lns_loan_headers_all
7293: ||
7294: || Target Tables: LNS_DISTRIBUTIONS
7295: ||
7296: || KNOWN ISSUES

Line 7371: from lns_loan_headers_all h

7367:
7368: cursor c_loan_info(c_loan_id NUMBER)
7369: is
7370: select h.loan_class_code, h.requested_amount, h.funded_amount, (nvl(subsidy_rate, 0)/100)
7371: from lns_loan_headers_all h
7372: where h.loan_id = c_loan_id;
7373:
7374:
7375: cursor c_num_receivables(c_loan_id number)

Line 9042: lns_loan_headers_all loan, lns_system_options_all lsysopt, hr_operating_units ou, gl_ledgers gl

9038: CURSOR loan_cur(C_LOAN_ID number) IS
9039: SELECT
9040: loan.loan_number, nvl(loan.disable_int_accrual_flag, 'N'), ou.name, gl.name
9041: FROM
9042: lns_loan_headers_all loan, lns_system_options_all lsysopt, hr_operating_units ou, gl_ledgers gl
9043: WHERE loan.loan_id = C_LOAN_ID
9044: AND loan.org_id = lsysopt.org_id
9045: AND lsysopt.set_of_books_id = gl.ledger_id
9046: AND loan.org_id = ou.organization_id;