DBA Data[Home] [Help]

APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on AR_CMGT_GUARANTOR_DATA

Line 4550: ar_cmgt_guarantor_data gdata,

4546: -- From lease application, get to the case folder and fetch all guarantors
4547: CURSOR c_get_guarantors(cp_lap_id IN okl_lease_applications_v.ID%TYPE) IS
4548: SELECT hzp.party_name, credreq.trx_amount amount_requested, gdata.*
4549: FROM ar_cmgt_credit_requests credreq,
4550: ar_cmgt_guarantor_data gdata,
4551: hz_parties hzp
4552: WHERE gdata.credit_request_id = credreq.credit_request_id
4553: AND credreq.source_column3 = 'LEASEAPP'
4554: AND credreq.source_column1 = cp_lap_id

Line 4595: ar_cmgt_guarantor_data gdata

4591: OR (p_role.rle_code = 'GUARANTOR'
4592: AND p_role.jtot_object1_code= 'OKX_PARTY'
4593: AND p_role.object1_id1 NOT IN ( SELECT gdata.PARTY_ID
4594: FROM ar_cmgt_credit_requests credreq,
4595: ar_cmgt_guarantor_data gdata
4596: WHERE gdata.credit_request_id = credreq.credit_request_id
4597: AND credreq.source_column3 = 'LEASEAPP'
4598: AND credreq.source_column1 = cp_lap_id
4599: )