APPS.AR_CMGT_AGING dependencies on LNS_LOAN_PARTICIPANTS_V

Line 233: from LNS_LOAN_PARTICIPANTS_V

229: union
230: select p_party_id from dual
231: UNION
232: select hz_party_id
233: from LNS_LOAN_PARTICIPANTS_V
234: where loan_id = pg_source_id
235: and participant_type_code = 'COBORROWER'
236: and pg_source_name = 'LNS'
237: and (end_date_active is null OR

Line 376: from LNS_LOAN_PARTICIPANTS_V

372: union
373: select p_party_id from dual
374: UNION
375: select hz_party_id
376: from LNS_LOAN_PARTICIPANTS_V
377: where loan_id = pg_source_id
378: and participant_type_code = 'COBORROWER'
379: and pg_source_name = 'LNS'
380: and (end_date_active is null OR

Line 500: from LNS_LOAN_PARTICIPANTS_V

496: union
497: select p_party_id from dual
498: UNION
499: select hz_party_id
500: from LNS_LOAN_PARTICIPANTS_V
501: where loan_id = pg_source_id
502: and participant_type_code = 'COBORROWER'
503: and pg_source_name = 'LNS'
504: and (end_date_active is null OR

Line 643: from LNS_LOAN_PARTICIPANTS_V

639: union
640: select p_party_id from dual
641: UNION
642: select hz_party_id
643: from LNS_LOAN_PARTICIPANTS_V
644: where loan_id = pg_source_id
645: and participant_type_code = 'COBORROWER'
646: and pg_source_name = 'LNS'
647: and (end_date_active is null OR