eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.LNS_LOAN_PUB dependencies on HZ_PARTIES

Line 983: FROM hz_parties hzp

979: ELSE
980: BEGIN
981: SELECT 'Y'
982: INTO l_dummy
983: FROM hz_parties hzp
984: WHERE hzp.party_id = P_Loan_Details_Rec.primary_borrower_party_id
985: AND hzp.party_type = l_product_rec.party_type
986: AND hzp.status = 'A';
987: l_borrower_valid := TRUE;

Line 1064: hz_parties p,

1060: SELECT
1061: p.party_id INTO l_contact_pers_party_id
1062: FROM
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,

Line 1065: hz_parties o,

1061: p.party_id INTO l_contact_pers_party_id
1062: FROM
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

Line 1066: hz_parties rel_party,

1062: FROM
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'

Line 1085: AND con_phone.owner_table_name(+) = 'HZ_PARTIES'

1081: AND rel.party_id = rel_party.party_id
1082: AND rel.status = 'A'
1083: AND rel_party.status = 'A'
1084: AND p.status = 'A'
1085: AND con_phone.owner_table_name(+) = 'HZ_PARTIES'
1086: AND con_phone.owner_table_id(+) = rel.party_id
1087: AND con_phone.primary_flag(+) = 'Y'
1088: AND con_phone.status(+) = 'A'
1089: AND con_phone.contact_point_type(+) = 'PHONE'

Line 1115: hz_parties p,

1111: SELECT
1112: rel.party_id INTO l_contact_rel_party_id
1113: FROM
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,

Line 1116: hz_parties o,

1112: rel.party_id INTO l_contact_rel_party_id
1113: FROM
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

Line 1117: hz_parties rel_party,

1113: FROM
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'

Line 1136: AND con_phone.owner_table_name(+) = 'HZ_PARTIES'

1132: AND rel.party_id = rel_party.party_id
1133: AND rel.status = 'A'
1134: AND rel_party.status = 'A'
1135: AND p.status = 'A'
1136: AND con_phone.owner_table_name(+) = 'HZ_PARTIES'
1137: AND con_phone.owner_table_id(+) = rel.party_id
1138: AND con_phone.primary_flag(+) = 'Y'
1139: AND con_phone.status(+) = 'A'
1140: AND con_phone.contact_point_type(+) = 'PHONE'

Line 1929: FROM hz_parties hzp

1925: ELSE
1926: BEGIN
1927: SELECT 'Y'
1928: INTO l_dummy
1929: FROM hz_parties hzp
1930: WHERE hzp.party_id = p_loan_part_tbl(l_count).hz_party_id
1931: AND hzp.status = 'A';
1932: l_borrower_valid := TRUE;
1933: EXCEPTION

Line 2009: hz_parties p,

2005: SELECT
2006: p.party_id INTO l_contact_pers_party_id
2007: FROM
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,

Line 2010: hz_parties o,

2006: p.party_id INTO l_contact_pers_party_id
2007: FROM
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

Line 2011: hz_parties rel_party,

2007: FROM
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'

Line 2030: AND con_phone.owner_table_name(+) = 'HZ_PARTIES'

2026: AND rel.party_id = rel_party.party_id
2027: AND rel.status = 'A'
2028: AND rel_party.status = 'A'
2029: AND p.status = 'A'
2030: AND con_phone.owner_table_name(+) = 'HZ_PARTIES'
2031: AND con_phone.owner_table_id(+) = rel.party_id
2032: AND con_phone.primary_flag(+) = 'Y'
2033: AND con_phone.status(+) = 'A'
2034: AND con_phone.contact_point_type(+) = 'PHONE'

Line 2060: hz_parties p,

2056: SELECT
2057: rel.party_id INTO l_contact_rel_party_id
2058: FROM
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,

Line 2061: hz_parties o,

2057: rel.party_id INTO l_contact_rel_party_id
2058: FROM
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

Line 2062: hz_parties rel_party,

2058: FROM
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'

Line 2081: AND con_phone.owner_table_name(+) = 'HZ_PARTIES'

2077: AND rel.party_id = rel_party.party_id
2078: AND rel.status = 'A'
2079: AND rel_party.status = 'A'
2080: AND p.status = 'A'
2081: AND con_phone.owner_table_name(+) = 'HZ_PARTIES'
2082: AND con_phone.owner_table_id(+) = rel.party_id
2083: AND con_phone.primary_flag(+) = 'Y'
2084: AND con_phone.status(+) = 'A'
2085: AND con_phone.contact_point_type(+) = 'PHONE'

Line 2774: FROM hz_parties hzp

2770: else
2771: BEGIN
2772: SELECT 'Y'
2773: INTO l_dummy
2774: FROM hz_parties hzp
2775: WHERE hzp.party_id = P_DISB_TBL(i).PAYEE_PARTY_ID
2776: AND hzp.status = 'A';
2777: EXCEPTION
2778: WHEN NO_DATA_FOUND THEN