APPS.LNS_BILLING_BATCH_PUB dependencies on LNS_LOOKUPS

Line 1072: from LNS_LOOKUPS

1068:
1069: /* query of meaning of PAYMENT_APPLICATION_TYPE */
1070: CURSOR meaning_cur(P_LOOKUP_CODE varchar2) IS
1071: select meaning
1072: from LNS_LOOKUPS
1073: where lookup_type = 'PAYMENT_APPLICATION_TYPE' and
1074: lookup_code = P_LOOKUP_CODE;
1075:
1076: /* query of distributions for principal dr */

Line 3252: 'lns_lookups fund_status, ' ||

3248: 'fnd_date.date_to_chardate((select max(DISBURSEMENT_DATE) from lns_disb_lines where DISB_HEADER_ID = head.DISB_HEADER_ID)) DISBURSEMENT_DATE, ' ||
3249: 'fund_status.meaning status, ' ||
3250: 'fund_act.meaning activity_name ' ||
3251: 'from lns_disb_headers head, ' ||
3252: 'lns_lookups fund_status, ' ||
3253: 'lns_lookups fund_act ' ||
3254: 'where head.loan_id = loan.loan_id and ' ||
3255: 'fund_status.lookup_type(+) = ''FUNDING_STATUS'' and ' ||
3256: 'fund_status.lookup_code(+) = head.STATUS and ' ||

Line 3253: 'lns_lookups fund_act ' ||

3249: 'fund_status.meaning status, ' ||
3250: 'fund_act.meaning activity_name ' ||
3251: 'from lns_disb_headers head, ' ||
3252: 'lns_lookups fund_status, ' ||
3253: 'lns_lookups fund_act ' ||
3254: 'where head.loan_id = loan.loan_id and ' ||
3255: 'fund_status.lookup_type(+) = ''FUNDING_STATUS'' and ' ||
3256: 'fund_status.lookup_code(+) = head.STATUS and ' ||
3257: 'fund_act.lookup_type(+) = ''DISB_ACTIVITY'' and ' ||

Line 3300: 'lns_lookups loan_class, ' ||

3296: 'hz_party_sites site, ' ||
3297: 'fnd_currencies_tl curr, ' ||
3298: 'hz_parties contact_person, ' ||
3299: 'lns_loan_types_vl loan_type, ' ||
3300: 'lns_lookups loan_class, ' ||
3301: 'lns_lookups periodlkup, ' ||
3302: 'lns_lookups loan_subtype, ' ||
3303: 'lns_terms terms, ' ||
3304: 'lns_int_rate_headers int_rate_hdr, ' ||

Line 3301: 'lns_lookups periodlkup, ' ||

3297: 'fnd_currencies_tl curr, ' ||
3298: 'hz_parties contact_person, ' ||
3299: 'lns_loan_types_vl loan_type, ' ||
3300: 'lns_lookups loan_class, ' ||
3301: 'lns_lookups periodlkup, ' ||
3302: 'lns_lookups loan_subtype, ' ||
3303: 'lns_terms terms, ' ||
3304: 'lns_int_rate_headers int_rate_hdr, ' ||
3305: 'lns_lookups rate_type, ' ||

Line 3302: 'lns_lookups loan_subtype, ' ||

3298: 'hz_parties contact_person, ' ||
3299: 'lns_loan_types_vl loan_type, ' ||
3300: 'lns_lookups loan_class, ' ||
3301: 'lns_lookups periodlkup, ' ||
3302: 'lns_lookups loan_subtype, ' ||
3303: 'lns_terms terms, ' ||
3304: 'lns_int_rate_headers int_rate_hdr, ' ||
3305: 'lns_lookups rate_type, ' ||
3306: 'lns_lookups rate_freq, ' ||

Line 3305: 'lns_lookups rate_type, ' ||

3301: 'lns_lookups periodlkup, ' ||
3302: 'lns_lookups loan_subtype, ' ||
3303: 'lns_terms terms, ' ||
3304: 'lns_int_rate_headers int_rate_hdr, ' ||
3305: 'lns_lookups rate_type, ' ||
3306: 'lns_lookups rate_freq, ' ||
3307: 'lns_lookups pay_freq, ' ||
3308: 'fnd_lookups open_to_term, ' ||
3309: 'lns_loan_products_vl product, ' ||

Line 3306: 'lns_lookups rate_freq, ' ||

3302: 'lns_lookups loan_subtype, ' ||
3303: 'lns_terms terms, ' ||
3304: 'lns_int_rate_headers int_rate_hdr, ' ||
3305: 'lns_lookups rate_type, ' ||
3306: 'lns_lookups rate_freq, ' ||
3307: 'lns_lookups pay_freq, ' ||
3308: 'fnd_lookups open_to_term, ' ||
3309: 'lns_loan_products_vl product, ' ||
3310: 'lns_rate_schedules rate_sched1, ' ||

Line 3307: 'lns_lookups pay_freq, ' ||

3303: 'lns_terms terms, ' ||
3304: 'lns_int_rate_headers int_rate_hdr, ' ||
3305: 'lns_lookups rate_type, ' ||
3306: 'lns_lookups rate_freq, ' ||
3307: 'lns_lookups pay_freq, ' ||
3308: 'fnd_lookups open_to_term, ' ||
3309: 'lns_loan_products_vl product, ' ||
3310: 'lns_rate_schedules rate_sched1, ' ||
3311: 'lns_rate_schedules rate_sched2 ' ||