DBA Data[Home] [Help]

APPS.LNS_SAMPLE_CUSTOM_CONDS dependencies on LNS_DISB_HEADERS

Line 443: 'LNS_DISB_HEADERS',

439: /* querying condition info */
440: CURSOR cond_info_cur(P_COND_ASSIGNMENT_ID number) IS
441: select cond_ass.LOAN_ID,
442: cond_ass.DISB_HEADER_ID,
443: 'LNS_DISB_HEADERS',
444: cond.CONDITION_ID,
445: cond.CONDITION_NAME,
446: cond.CONDITION_DESCRIPTION,
447: cond.CONDITION_TYPE,

Line 608: 'LNS_DISB_HEADERS',

604: /* querying condition info */
605: CURSOR cond_info_cur(P_COND_ASSIGNMENT_ID number) IS
606: select cond_ass.LOAN_ID,
607: cond_ass.DISB_HEADER_ID,
608: 'LNS_DISB_HEADERS',
609: cond.CONDITION_ID,
610: cond.CONDITION_NAME,
611: cond.CONDITION_DESCRIPTION,
612: cond.CONDITION_TYPE,

Line 772: 'LNS_DISB_HEADERS',

768: /* querying condition info */
769: CURSOR cond_info_cur(P_COND_ASSIGNMENT_ID number) IS
770: select cond_ass.LOAN_ID,
771: cond_ass.DISB_HEADER_ID,
772: 'LNS_DISB_HEADERS',
773: cond.CONDITION_ID,
774: cond.CONDITION_NAME,
775: cond.CONDITION_DESCRIPTION,
776: cond.CONDITION_TYPE,

Line 786: from lns_disb_headers

782:
783: /* querying loan requested amount */
784: CURSOR due_date_cur(P_DISB_HEADER_ID number) IS
785: select PAYMENT_REQUEST_DATE
786: from lns_disb_headers
787: where disb_header_id = P_DISB_HEADER_ID;
788:
789: BEGIN
790:

Line 933: 'LNS_DISB_HEADERS',

929: /* querying condition info */
930: CURSOR cond_info_cur(P_COND_ASSIGNMENT_ID number) IS
931: select cond_ass.LOAN_ID,
932: cond_ass.DISB_HEADER_ID,
933: 'LNS_DISB_HEADERS',
934: cond.CONDITION_ID,
935: cond.CONDITION_NAME,
936: cond.CONDITION_DESCRIPTION,
937: cond.CONDITION_TYPE,

Line 947: from lns_disb_headers

943:
944: /* querying loan requested amount */
945: CURSOR due_date_cur(P_DISB_HEADER_ID number) IS
946: select PAYMENT_REQUEST_DATE
947: from lns_disb_headers
948: where disb_header_id = P_DISB_HEADER_ID;
949:
950: BEGIN
951: