APPS.LNS_BILLING_BATCH_PUB dependencies on LNS_LOOKUPS

Line 1088: from LNS_LOOKUPS

1084:
1085: /* query of meaning of PAYMENT_APPLICATION_TYPE */
1086: CURSOR meaning_cur(P_LOOKUP_CODE varchar2) IS
1087: select meaning
1088: from LNS_LOOKUPS
1089: where lookup_type = 'PAYMENT_APPLICATION_TYPE' and
1090: lookup_code = P_LOOKUP_CODE;
1091:
1092: /* query of distributions for principal dr */

Line 3523: 'lns_lookups fund_status, ' ||

3519: 'fnd_date.date_to_chardate((select max(DISBURSEMENT_DATE) from lns_disb_lines where DISB_HEADER_ID = head.DISB_HEADER_ID)) DISBURSEMENT_DATE, ' ||
3520: 'fund_status.meaning status, ' ||
3521: 'fund_act.meaning activity_name ' ||
3522: 'from lns_disb_headers head, ' ||
3523: 'lns_lookups fund_status, ' ||
3524: 'lns_lookups fund_act ' ||
3525: 'where head.loan_id = loan.loan_id and ' ||
3526: 'fund_status.lookup_type(+) = ''FUNDING_STATUS'' and ' ||
3527: 'fund_status.lookup_code(+) = head.STATUS and ' ||

Line 3524: 'lns_lookups fund_act ' ||

3520: 'fund_status.meaning status, ' ||
3521: 'fund_act.meaning activity_name ' ||
3522: 'from lns_disb_headers head, ' ||
3523: 'lns_lookups fund_status, ' ||
3524: 'lns_lookups fund_act ' ||
3525: 'where head.loan_id = loan.loan_id and ' ||
3526: 'fund_status.lookup_type(+) = ''FUNDING_STATUS'' and ' ||
3527: 'fund_status.lookup_code(+) = head.STATUS and ' ||
3528: 'fund_act.lookup_type(+) = ''DISB_ACTIVITY'' and ' ||

Line 3573: 'lns_lookups loan_class, ' ||

3569: 'hz_party_sites site, ' ||
3570: 'fnd_currencies_tl curr, ' ||
3571: 'hz_parties contact_person, ' ||
3572: 'lns_loan_types_vl loan_type, ' ||
3573: 'lns_lookups loan_class, ' ||
3574: 'lns_lookups periodlkup, ' ||
3575: 'lns_lookups loan_subtype, ' ||
3576: 'lns_terms terms, ' ||
3577: 'lns_int_rate_headers_vl int_rate_hdr, ' ||

Line 3574: 'lns_lookups periodlkup, ' ||

3570: 'fnd_currencies_tl curr, ' ||
3571: 'hz_parties contact_person, ' ||
3572: 'lns_loan_types_vl loan_type, ' ||
3573: 'lns_lookups loan_class, ' ||
3574: 'lns_lookups periodlkup, ' ||
3575: 'lns_lookups loan_subtype, ' ||
3576: 'lns_terms terms, ' ||
3577: 'lns_int_rate_headers_vl int_rate_hdr, ' ||
3578: 'lns_lookups rate_type, ' ||

Line 3575: 'lns_lookups loan_subtype, ' ||

3571: 'hz_parties contact_person, ' ||
3572: 'lns_loan_types_vl loan_type, ' ||
3573: 'lns_lookups loan_class, ' ||
3574: 'lns_lookups periodlkup, ' ||
3575: 'lns_lookups loan_subtype, ' ||
3576: 'lns_terms terms, ' ||
3577: 'lns_int_rate_headers_vl int_rate_hdr, ' ||
3578: 'lns_lookups rate_type, ' ||
3579: 'lns_lookups rate_freq, ' ||

Line 3578: 'lns_lookups rate_type, ' ||

3574: 'lns_lookups periodlkup, ' ||
3575: 'lns_lookups loan_subtype, ' ||
3576: 'lns_terms terms, ' ||
3577: 'lns_int_rate_headers_vl int_rate_hdr, ' ||
3578: 'lns_lookups rate_type, ' ||
3579: 'lns_lookups rate_freq, ' ||
3580: 'lns_lookups pay_freq, ' ||
3581: 'fnd_lookups open_to_term, ' ||
3582: 'lns_loan_products_vl product, ' ||

Line 3579: 'lns_lookups rate_freq, ' ||

3575: 'lns_lookups loan_subtype, ' ||
3576: 'lns_terms terms, ' ||
3577: 'lns_int_rate_headers_vl int_rate_hdr, ' ||
3578: 'lns_lookups rate_type, ' ||
3579: 'lns_lookups rate_freq, ' ||
3580: 'lns_lookups pay_freq, ' ||
3581: 'fnd_lookups open_to_term, ' ||
3582: 'lns_loan_products_vl product, ' ||
3583: 'lns_rate_schedules rate_sched1, ' ||

Line 3580: 'lns_lookups pay_freq, ' ||

3576: 'lns_terms terms, ' ||
3577: 'lns_int_rate_headers_vl int_rate_hdr, ' ||
3578: 'lns_lookups rate_type, ' ||
3579: 'lns_lookups rate_freq, ' ||
3580: 'lns_lookups pay_freq, ' ||
3581: 'fnd_lookups open_to_term, ' ||
3582: 'lns_loan_products_vl product, ' ||
3583: 'lns_rate_schedules rate_sched1, ' ||
3584: 'lns_rate_schedules rate_sched2 ' ||

Line 9377: lns_lookups look

9373: from
9374: lns_amortization_scheds am,
9375: lns_loan_headers loan,
9376: ar_payment_schedules psa,
9377: lns_lookups look
9378: where
9379: am.loan_id = P_LOAN_ID and
9380: am.amortization_schedule_id = P_AMORTIZATION_SCHED_ID and
9381: loan.loan_id = am.loan_id and