[Home] [Help]
766: ELSIF P_Loan_Details_Rec.trx_type_id IS NOT NULL AND l_product_rec.loan_class_code = 'ERS' THEN
767: BEGIN
768: SELECT 'Y'
769: INTO l_dummy
770: FROM ar_lookups alk
771: ,RA_CUST_TRX_TYPES_ALL rtyp
772: WHERE rtyp.CUST_TRX_TYPE_ID = P_Loan_Details_Rec.trx_type_id
773: AND alk.lookup_code = rtyp.type
774: AND alk.lookup_type = 'INV/CM';
1063: hz_relationships rel,
1064: hz_parties p,
1065: hz_parties o,
1066: hz_parties rel_party,
1067: ar_lookups lkup,
1068: hz_relationship_types rel_type,
1069: hz_contact_points con_phone
1070: WHERE o.party_type = 'ORGANIZATION'
1071: AND p.party_type = 'PERSON'
1114: hz_relationships rel,
1115: hz_parties p,
1116: hz_parties o,
1117: hz_parties rel_party,
1118: ar_lookups lkup,
1119: hz_relationship_types rel_type,
1120: hz_contact_points con_phone
1121: WHERE o.party_type = 'ORGANIZATION'
1122: AND p.party_type = 'PERSON'
2008: hz_relationships rel,
2009: hz_parties p,
2010: hz_parties o,
2011: hz_parties rel_party,
2012: ar_lookups lkup,
2013: hz_relationship_types rel_type,
2014: hz_contact_points con_phone
2015: WHERE o.party_type = 'ORGANIZATION'
2016: AND p.party_type = 'PERSON'
2059: hz_relationships rel,
2060: hz_parties p,
2061: hz_parties o,
2062: hz_parties rel_party,
2063: ar_lookups lkup,
2064: hz_relationship_types rel_type,
2065: hz_contact_points con_phone
2066: WHERE o.party_type = 'ORGANIZATION'
2067: AND p.party_type = 'PERSON'
2181: FROM
2182: ar_payment_schedules_all pmt_sch,
2183: hz_cust_accounts account,
2184: RA_CUST_TRX_TYPES trx_type,
2185: ar_lookups trx_type_lkup,
2186: ar_lookups trx_class_lkup
2187: WHERE
2188: pmt_sch.class in ('INV','DM') and
2189: pmt_sch.status = 'OP' and
2182: ar_payment_schedules_all pmt_sch,
2183: hz_cust_accounts account,
2184: RA_CUST_TRX_TYPES trx_type,
2185: ar_lookups trx_type_lkup,
2186: ar_lookups trx_class_lkup
2187: WHERE
2188: pmt_sch.class in ('INV','DM') and
2189: pmt_sch.status = 'OP' and
2190: pmt_sch.amount_due_remaining > 0 and