APPS.LNS_DISTRIBUTIONS_PUB dependencies on LNS_DISB_HEADERS

Line 81: from lns_disb_headers

77: where loan_id = p_loan_id;
78:
79: cursor c_disbursements(p_loan_id number) is
80: select disb_header_id
81: from lns_disb_headers
82: where loan_id = p_loan_id
83: and disbursement_number = 1;
84:
85: begin

Line 428: from lns_disb_headers

424: and xle.process_status_code <> 'P';
425:
426: cursor c_disbursements(p_loan_id number) is
427: select disb_header_id
428: from lns_disb_headers
429: where loan_id = p_loan_id
430: and disbursement_number = 1;
431:
432: cursor c_obj_vers(p_loan_id number) is

Line 856: ,lns_disb_headers d

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

Line 3038: from lns_disb_headers

3034: and disb_header_id = p_disb_header_id;
3035:
3036: cursor c_first_disb(p_loan_id number) is
3037: select disb_header_id
3038: from lns_disb_headers
3039: where loan_id = p_loan_id;
3040:
3041: cursor c_subsidy_rows_exist(p_loan_id number) is
3042: select count(1)

Line 4145: from lns_disb_headers dh

4141: and entity_code = 'LOANS'
4142: and source_id_int_1 = p_loan_id
4143: and source_id_int_2 IN
4144: (select disb.disb_header_id
4145: from lns_disb_headers dh
4146: ,lns_distributions disb
4147: where disb.loan_id = p_loan_id
4148: and disb.disb_header_id = dh.disb_header_id
4149: and disb.account_name = 'LOAN_RECEIVABLE'

Line 4214: from lns_disb_headers dh

4210: where application_id = 206
4211: and entity_code = 'LOANS'
4212: and source_id_int_1 = p_loan_id
4213: and source_id_int_2 in (select disb.disb_header_id
4214: from lns_disb_headers dh
4215: ,lns_distributions disb
4216: where disb.loan_id = p_loan_id
4217: and disb.disb_header_id = dh.disb_header_id
4218: and disb.account_name = 'LOAN_RECEIVABLE'