APPS.AR_CMGT_DATA_POINTS_PKG dependencies on LNS_LOAN_PARTICIPANTS_V

Line 227: from LNS_LOAN_PARTICIPANTS_V

223: UNION
224: select p_party_id from dual
225: UNION
226: select hz_party_id
227: from LNS_LOAN_PARTICIPANTS_V
228: where loan_id = g_source_id
229: and participant_type_code = 'COBORROWER'
230: and g_source_name = 'LNS'
231: and (end_date_active is null OR

Line 448: from LNS_LOAN_PARTICIPANTS_V

444: and :4 <> ''LNS''
445: union select :5 from dual
446: union
447: select hz_party_id
448: from LNS_LOAN_PARTICIPANTS_V
449: where loan_id = :6
450: and participant_type_code = ''COBORROWER''
451: and :7 = ''LNS''
452: and (end_date_active is null OR

Line 720: FROM LNS_LOAN_PARTICIPANTS_V

716: UNION
717: SELECT p_party_id FROM DUAL
718: UNION
719: SELECT hz_party_id
720: FROM LNS_LOAN_PARTICIPANTS_V
721: WHERE loan_id = g_source_id
722: AND participant_type_code = 'COBORROWER'
723: AND g_source_name = 'LNS'
724: AND (end_date_active is null OR

Line 842: from LNS_LOAN_PARTICIPANTS_V

838: and g_source_name <> 'LNS'
839: union select p_party_id from dual
840: UNION
841: select hz_party_id
842: from LNS_LOAN_PARTICIPANTS_V
843: where loan_id = g_source_id
844: and participant_type_code = 'COBORROWER'
845: and g_source_name = 'LNS'
846: and (end_date_active is null OR

Line 875: from LNS_LOAN_PARTICIPANTS_V

871: and g_source_name <> 'LNS'
872: union select p_party_id from dual
873: UNION
874: select hz_party_id
875: from LNS_LOAN_PARTICIPANTS_V
876: where loan_id = g_source_id
877: and participant_type_code = 'COBORROWER'
878: and g_source_name = 'LNS'
879: and (end_date_active is null OR

Line 1094: from LNS_LOAN_PARTICIPANTS_V

1090: and g_source_name <> 'LNS'
1091: union select p_party_id from dual
1092: UNION
1093: select hz_party_id
1094: from LNS_LOAN_PARTICIPANTS_V
1095: where loan_id = g_source_id
1096: and participant_type_code = 'COBORROWER'
1097: and g_source_name = 'LNS'
1098: and (end_date_active is null OR

Line 4805: from LNS_LOAN_PARTICIPANTS_V

4801: and g_source_name <> 'LNS'
4802: union select p_party_id from dual
4803: UNION
4804: select hz_party_id
4805: from LNS_LOAN_PARTICIPANTS_V
4806: where loan_id = g_source_id
4807: and participant_type_code = 'COBORROWER'
4808: and g_source_name = 'LNS'
4809: and (end_date_active is null OR

Line 5207: from LNS_LOAN_PARTICIPANTS_V

5203: and g_source_name <> 'LNS'
5204: union select p_party_id from dual
5205: UNION
5206: select hz_party_id
5207: from LNS_LOAN_PARTICIPANTS_V
5208: where loan_id = g_source_id
5209: and participant_type_code = 'COBORROWER'
5210: and g_source_name = 'LNS'
5211: and (end_date_active is null OR

Line 5461: from LNS_LOAN_PARTICIPANTS_V

5457: and g_source_name <> 'LNS'
5458: union select p_party_id from dual
5459: UNION
5460: select hz_party_id
5461: from LNS_LOAN_PARTICIPANTS_V
5462: where loan_id = g_source_id
5463: and participant_type_code = 'COBORROWER'
5464: and g_source_name = 'LNS'
5465: and (end_date_active is null OR

Line 5565: from LNS_LOAN_PARTICIPANTS_V

5561: and g_source_name <> 'LNS'
5562: union select p_party_id from dual
5563: UNION
5564: select hz_party_id
5565: from LNS_LOAN_PARTICIPANTS_V
5566: where loan_id = g_source_id
5567: and participant_type_code = 'COBORROWER'
5568: and g_source_name = 'LNS'
5569: and (end_date_active is null OR