APPS.HZ_MERGE_ENTITY_ATTRI_PVT dependencies on HZ_MERGE_PARTIES

Line 1087: from hz_organization_profiles pro, hz_merge_parties mp

1083:
1084: -- get candidate parties with desc order for last update date
1085: cursor get_org_candidate_party_csr is
1086: select mp.from_party_id, pro.last_update_date
1087: from hz_organization_profiles pro, hz_merge_parties mp
1088: where pro.party_id = mp.from_party_id
1089: and mp.batch_id = p_merge_batch_id
1090: and sysdate between pro.effective_start_date and nvl(pro.effective_end_date,sysdate)
1091: order by pro.last_update_date desc;

Line 1096: from hz_organization_profiles pro, hz_merge_parties mp

1092:
1093: -- get candidate parties with desc order for latest creation date
1094: cursor get_org_candidate_party_lc_csr is
1095: select mp.from_party_id, pro.last_update_date
1096: from hz_organization_profiles pro, hz_merge_parties mp
1097: where pro.party_id = mp.from_party_id
1098: and mp.batch_id = p_merge_batch_id
1099: and sysdate between pro.effective_start_date and nvl(pro.effective_end_date,sysdate)
1100: order by pro.creation_date desc, pro.party_id desc;

Line 1105: from hz_organization_profiles pro, hz_merge_parties mp

1101:
1102: -- get candidate parties with desc order for earlist creation date
1103: cursor get_org_candidate_party_ec_csr is
1104: select mp.from_party_id, pro.last_update_date
1105: from hz_organization_profiles pro, hz_merge_parties mp
1106: where pro.party_id = mp.from_party_id
1107: and mp.batch_id = p_merge_batch_id
1108: and sysdate between pro.effective_start_date and nvl(pro.effective_end_date,sysdate)
1109: order by pro.creation_date, pro.party_id;

Line 1114: from hz_person_profiles pro, hz_merge_parties mp

1110:
1111: -- get candidate parties with desc order for last update date
1112: cursor get_per_candidate_party_csr is
1113: select mp.from_party_id, pro.last_update_date
1114: from hz_person_profiles pro, hz_merge_parties mp
1115: where pro.party_id = mp.from_party_id
1116: and mp.batch_id = p_merge_batch_id
1117: and sysdate between pro.effective_start_date and nvl(pro.effective_end_date,sysdate)
1118: order by pro.last_update_date desc;

Line 1123: from hz_person_profiles pro, hz_merge_parties mp

1119:
1120: -- get candidate parties with desc order for last creation date
1121: cursor get_per_candidate_party_lc_csr is
1122: select mp.from_party_id, pro.last_update_date
1123: from hz_person_profiles pro, hz_merge_parties mp
1124: where pro.party_id = mp.from_party_id
1125: and mp.batch_id = p_merge_batch_id
1126: and sysdate between pro.effective_start_date and nvl(pro.effective_end_date,sysdate)
1127: order by pro.creation_date desc, pro.party_id desc;

Line 1132: from hz_person_profiles pro, hz_merge_parties mp

1128:
1129: -- get candidate parties with desc order for earlist creation date
1130: cursor get_per_candidate_party_ec_csr is
1131: select mp.from_party_id, pro.last_update_date
1132: from hz_person_profiles pro, hz_merge_parties mp
1133: where pro.party_id = mp.from_party_id
1134: and mp.batch_id = p_merge_batch_id
1135: and sysdate between pro.effective_start_date and nvl(pro.effective_end_date,sysdate)
1136: order by pro.creation_date, pro.party_id;

Line 1364: from hz_organization_profiles pro, hz_merge_parties mp

1360:
1361: -- get candidate parties with desc order for last update date
1362: cursor get_business_report_party_csr is
1363: select mp.from_party_id, pro.last_update_date
1364: from hz_organization_profiles pro, hz_merge_parties mp
1365: where pro.party_id = mp.from_party_id
1366: and mp.batch_id = p_merge_batch_id
1367: and pro.business_report is not null
1368: and sysdate between pro.effective_start_date and nvl(pro.effective_end_date,sysdate)