APPS.AR_CMGT_DATA_POINTS_PKG dependencies on LNS_LOAN_PARTICIPANTS_V

Line 286: from LNS_LOAN_PARTICIPANTS_V

282: UNION
283: select p_party_id from dual
284: UNION
285: select hz_party_id
286: from LNS_LOAN_PARTICIPANTS_V
287: where loan_id = g_source_id
288: and participant_type_code = 'COBORROWER'
289: and g_source_name = 'LNS'
290: and (end_date_active is null OR

Line 507: from LNS_LOAN_PARTICIPANTS_V

503: and :4 <> ''LNS''
504: union select :5 from dual
505: union
506: select hz_party_id
507: from LNS_LOAN_PARTICIPANTS_V
508: where loan_id = :6
509: and participant_type_code = ''COBORROWER''
510: and :7 = ''LNS''
511: and (end_date_active is null OR

Line 779: FROM LNS_LOAN_PARTICIPANTS_V

775: UNION
776: SELECT p_party_id FROM DUAL
777: UNION
778: SELECT hz_party_id
779: FROM LNS_LOAN_PARTICIPANTS_V
780: WHERE loan_id = g_source_id
781: AND participant_type_code = 'COBORROWER'
782: AND g_source_name = 'LNS'
783: AND (end_date_active is null OR

Line 901: from LNS_LOAN_PARTICIPANTS_V

897: and g_source_name <> 'LNS'
898: union select p_party_id from dual
899: UNION
900: select hz_party_id
901: from LNS_LOAN_PARTICIPANTS_V
902: where loan_id = g_source_id
903: and participant_type_code = 'COBORROWER'
904: and g_source_name = 'LNS'
905: and (end_date_active is null OR

Line 934: from LNS_LOAN_PARTICIPANTS_V

930: and g_source_name <> 'LNS'
931: union select p_party_id from dual
932: UNION
933: select hz_party_id
934: from LNS_LOAN_PARTICIPANTS_V
935: where loan_id = g_source_id
936: and participant_type_code = 'COBORROWER'
937: and g_source_name = 'LNS'
938: and (end_date_active is null OR

Line 1153: from LNS_LOAN_PARTICIPANTS_V

1149: and g_source_name <> 'LNS'
1150: union select p_party_id from dual
1151: UNION
1152: select hz_party_id
1153: from LNS_LOAN_PARTICIPANTS_V
1154: where loan_id = g_source_id
1155: and participant_type_code = 'COBORROWER'
1156: and g_source_name = 'LNS'
1157: and (end_date_active is null OR

Line 4884: from LNS_LOAN_PARTICIPANTS_V

4880: and g_source_name <> 'LNS'
4881: union select p_party_id from dual
4882: UNION
4883: select hz_party_id
4884: from LNS_LOAN_PARTICIPANTS_V
4885: where loan_id = g_source_id
4886: and participant_type_code = 'COBORROWER'
4887: and g_source_name = 'LNS'
4888: and (end_date_active is null OR

Line 5256: from LNS_LOAN_PARTICIPANTS_V

5252: and g_source_name <> 'LNS'
5253: union select p_party_id from dual
5254: UNION
5255: select hz_party_id
5256: from LNS_LOAN_PARTICIPANTS_V
5257: where loan_id = g_source_id
5258: and participant_type_code = 'COBORROWER'
5259: and g_source_name = 'LNS'
5260: and (end_date_active is null OR

Line 5510: from LNS_LOAN_PARTICIPANTS_V

5506: and g_source_name <> 'LNS'
5507: union select p_party_id from dual
5508: UNION
5509: select hz_party_id
5510: from LNS_LOAN_PARTICIPANTS_V
5511: where loan_id = g_source_id
5512: and participant_type_code = 'COBORROWER'
5513: and g_source_name = 'LNS'
5514: and (end_date_active is null OR

Line 5614: from LNS_LOAN_PARTICIPANTS_V

5610: and g_source_name <> 'LNS'
5611: union select p_party_id from dual
5612: UNION
5613: select hz_party_id
5614: from LNS_LOAN_PARTICIPANTS_V
5615: where loan_id = g_source_id
5616: and participant_type_code = 'COBORROWER'
5617: and g_source_name = 'LNS'
5618: and (end_date_active is null OR

Line 6298: from LNS_LOAN_PARTICIPANTS_V

6294: and g_source_name <> 'LNS'
6295: union select p_party_id from dual
6296: UNION
6297: select hz_party_id
6298: from LNS_LOAN_PARTICIPANTS_V
6299: where loan_id = g_source_id
6300: and participant_type_code = 'COBORROWER'
6301: and g_source_name = 'LNS'
6302: and (end_date_active is null OR