APPS.LNS_DISTRIBUTIONS_PUB dependencies on LNS_DISB_HEADERS

Line 87: from lns_disb_headers

83: where loan_id = p_loan_id;
84:
85: cursor c_disbursements(p_loan_id number) is
86: select disb_header_id
87: from lns_disb_headers
88: where loan_id = p_loan_id
89: and disbursement_number = 1;
90:
91: begin

Line 543: from lns_disb_headers

539: order by event_id desc;
540:
541: cursor c_disbursements(p_loan_id number) is
542: select disb_header_id
543: from lns_disb_headers
544: where loan_id = p_loan_id
545: and disbursement_number = 1;
546:
547: cursor c_obj_vers(p_loan_id number) is

Line 1063: ,lns_disb_headers d

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
1066: and h.loan_id = d.loan_id
1067: and d.disb_header_id = p_disb_header_id;

Line 3798: from lns_disb_headers

3794: AND distribution_type = 'ORIGINATION';
3795:
3796: cursor c_first_disb(p_loan_id number) is
3797: select disb_header_id
3798: from lns_disb_headers
3799: where loan_id = p_loan_id;
3800:
3801: cursor c_subsidy_rows_exist(p_loan_id number) is
3802: select count(1)

Line 5106: from lns_disb_headers dh

5102: and entity_code = 'LOANS'
5103: and source_id_int_1 = p_loan_id
5104: and source_id_int_2 IN
5105: (select disb.disb_header_id
5106: from lns_disb_headers dh
5107: ,lns_distributions disb
5108: where disb.loan_id = p_loan_id
5109: and disb.disb_header_id = dh.disb_header_id
5110: and disb.account_name = 'LOAN_RECEIVABLE'

Line 5203: from lns_disb_headers dh

5199: and entity_code = 'LOANS'
5200: and source_id_int_1 = p_loan_id
5201: and (source_id_int_2 = -1
5202: OR source_id_int_2 in (select disb.disb_header_id
5203: from lns_disb_headers dh
5204: ,lns_distributions disb
5205: where disb.loan_id = p_loan_id
5206: and disb.disb_header_id = dh.disb_header_id
5207: and disb.account_name = 'LOAN_RECEIVABLE'

Line 7670: from lns_disb_headers

7666: where loan_id = p_loan_id;
7667:
7668: cursor c_disbursements(p_loan_id number) is
7669: select disb_header_id
7670: from lns_disb_headers
7671: where loan_id = p_loan_id
7672: and disbursement_number = 1;
7673:
7674: cursor c_disb_info(p_disb_header_id number) is

Line 7676: from lns_disb_headers

7672: and disbursement_number = 1;
7673:
7674: cursor c_disb_info(p_disb_header_id number) is
7675: select PAYMENT_REQUEST_DATE
7676: from lns_disb_headers
7677: where disb_header_id = p_disb_header_id;
7678:
7679: begin
7680:

Line 10156: from lns_disb_headers d

10152: -- R12 for loan_types
10153: cursor c_disbursement_info(p_loan_id NUMBER, p_disb_header_id number)
10154: is
10155: select d.header_amount
10156: from lns_disb_headers d
10157: where d.loan_id = p_loan_id
10158: and d.disb_header_id = p_disb_header_id;
10159:
10160: cursor c_loan_adjustment_info(c_loan_id NUMBER, c_loan_amount_adj_id number)