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.HZ_STAGE_MAP_TRANSFORM dependencies on HZ_PARTIES

Line 495: FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op

491: ,op.SIC_CODE_TYPE
492: ,p.CATEGORY_CODE
493: ,p.REFERENCE_USE_FLAG
494: ,op.CORPORATION_CLASS
495: FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op
496: WHERE p.rowid BETWEEN p_start_rowid and p_end_rowid
497: AND p.party_id = op.party_id
498: AND op.effective_end_date is NULL
499: AND p.PARTY_TYPE ='ORGANIZATION';

Line 516: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe

512: ,NULL
513: ,p.CATEGORY_CODE
514: ,p.REFERENCE_USE_FLAG
515: ,NULL
516: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe
517: WHERE p.rowid BETWEEN p_start_rowid and p_end_rowid
518: AND p.party_id = pe.party_id
519: AND pe.effective_end_date is NULL
520: AND p.PARTY_TYPE ='PERSON';

Line 537: FROM HZ_PARTIES p

533: ,NULL
534: ,p.CATEGORY_CODE
535: ,p.REFERENCE_USE_FLAG
536: ,NULL
537: FROM HZ_PARTIES p
538: WHERE p.rowid BETWEEN p_start_rowid and p_end_rowid
539: AND p.party_type <> 'PERSON'
540: AND p.party_type <> 'ORGANIZATION'
541: AND p.party_type <> 'PARTY_RELATIONSHIP';

Line 560: FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op

556: ,op.SIC_CODE_TYPE
557: ,p.CATEGORY_CODE
558: ,p.REFERENCE_USE_FLAG
559: ,op.CORPORATION_CLASS
560: FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op
561: WHERE p.rowid BETWEEN p_start_rowid and p_end_rowid
562: AND NOT EXISTS (select 1 FROM HZ_STAGED_PARTIES sp
563: WHERE sp.party_id = p.party_id)
564: AND p.party_id = op.party_id

Line 583: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe

579: ,NULL
580: ,p.CATEGORY_CODE
581: ,p.REFERENCE_USE_FLAG
582: ,NULL
583: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe
584: WHERE p.rowid BETWEEN p_start_rowid and p_end_rowid
585: AND NOT EXISTS (select 1 FROM HZ_STAGED_PARTIES sp
586: WHERE sp.party_id = p.party_id)
587: AND p.party_id = pe.party_id

Line 606: FROM HZ_PARTIES p

602: ,NULL
603: ,p.CATEGORY_CODE
604: ,p.REFERENCE_USE_FLAG
605: ,NULL
606: FROM HZ_PARTIES p
607: WHERE p.rowid BETWEEN p_start_rowid and p_end_rowid
608: AND NOT EXISTS (select 1 FROM HZ_STAGED_PARTIES sp
609: WHERE sp.party_id = p.party_id)
610: AND p.party_type <> 'PERSON'

Line 843: FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op

839: , H_TX47(1)
840: , H_TX48(1)
841: , H_TX156(1)
842: , H_TX157(1)
843: FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op
844: WHERE p.party_id = p_party_id
845: AND p.party_id = op.party_id
846: AND (p.status = 'M' or op.effective_end_date is NULL) AND ROWNUM=1;
847: ELSIF p_party_type = 'PERSON' THEN

Line 876: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe

872: , H_TX47(1)
873: , H_TX48(1)
874: , H_TX156(1)
875: , H_TX157(1)
876: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe
877: WHERE p.party_id = p_party_id
878: AND p.party_id = pe.party_id
879: AND (p.status = 'M' or pe.effective_end_date is NULL) AND ROWNUM=1;
880: ELSE

Line 909: FROM HZ_PARTIES p

905: , H_TX47(1)
906: , H_TX48(1)
907: , H_TX156(1)
908: , H_TX157(1)
909: FROM HZ_PARTIES p
910: WHERE p.party_id = p_party_id;
911: END IF;
912: H_TX32(1):=HZ_PARTY_ACQUIRE.get_account_info(H_P_PARTY_ID(1),'PARTY','ALL_ACCOUNT_NAMES', 'STAGE');
913: H_TX35(1):=HZ_PARTY_ACQUIRE.get_account_info(H_P_PARTY_ID(1),'PARTY','ALL_ACCOUNT_NUMBERS', 'STAGE');

Line 1091: AND pr.subject_table_name = 'HZ_PARTIES'

1087: SELECT oc.org_contact_id
1088: FROM HZ_RELATIONSHIPS pr, HZ_ORG_CONTACTS oc
1089: WHERE pr.relationship_id = oc.party_relationship_id
1090: AND pr.subject_id = p_party_id
1091: AND pr.subject_table_name = 'HZ_PARTIES'
1092: AND pr.object_table_name = 'HZ_PARTIES'
1093: AND pr.directional_flag = 'F';
1094:
1095: BEGIN

Line 1092: AND pr.object_table_name = 'HZ_PARTIES'

1088: FROM HZ_RELATIONSHIPS pr, HZ_ORG_CONTACTS oc
1089: WHERE pr.relationship_id = oc.party_relationship_id
1090: AND pr.subject_id = p_party_id
1091: AND pr.subject_table_name = 'HZ_PARTIES'
1092: AND pr.object_table_name = 'HZ_PARTIES'
1093: AND pr.directional_flag = 'F';
1094:
1095: BEGIN
1096:

Line 1099: FROM hz_parties WHERE party_id = p_party_id;

1095: BEGIN
1096:
1097: -- Get party_type
1098: SELECT party_type INTO l_party_type
1099: FROM hz_parties WHERE party_id = p_party_id;
1100:
1101: -- Set global G_PARTY_TYPE variable value
1102: hz_trans_pkg.set_party_type(l_party_type);
1103:

Line 1155: FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op

1151: , H_TX47(1)
1152: , H_TX48(1)
1153: , H_TX156(1)
1154: , H_TX157(1)
1155: FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op
1156: WHERE p.party_id = p_party_id
1157: AND p.party_id = op.party_id
1158: AND (p.status = 'M' or op.effective_end_date is NULL) AND ROWNUM=1;
1159: ELSIF l_party_type = 'PERSON' THEN

Line 1188: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe

1184: , H_TX47(1)
1185: , H_TX48(1)
1186: , H_TX156(1)
1187: , H_TX157(1)
1188: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe
1189: WHERE p.party_id = p_party_id
1190: AND p.party_id = pe.party_id
1191: AND (p.status = 'M' or pe.effective_end_date is NULL) AND ROWNUM=1;
1192: ELSE

Line 1221: FROM HZ_PARTIES p

1217: , H_TX47(1)
1218: , H_TX48(1)
1219: , H_TX156(1)
1220: , H_TX157(1)
1221: FROM HZ_PARTIES p
1222: WHERE p.party_id = p_party_id;
1223: END IF;
1224:
1225: H_TX32(1):=HZ_PARTY_ACQUIRE.get_account_info(H_P_PARTY_ID(1),'PARTY','ALL_ACCOUNT_NAMES', 'STAGE');

Line 1426: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

1422: HZ_ORG_CONTACTS oc, HZ_PERSON_PROFILES pp
1423: WHERE oc.party_relationship_id = r.relationship_id
1424: AND r.object_id = g.party_id
1425: AND r.subject_id = pp.party_id
1426: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1427: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1428: AND DIRECTIONAL_FLAG= 'F'
1429: AND pp.effective_end_date is NULL
1430: AND (oc.status is null OR oc.status = 'A' or oc.status = 'I')

Line 1427: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'

1423: WHERE oc.party_relationship_id = r.relationship_id
1424: AND r.object_id = g.party_id
1425: AND r.subject_id = pp.party_id
1426: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1427: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1428: AND DIRECTIONAL_FLAG= 'F'
1429: AND pp.effective_end_date is NULL
1430: AND (oc.status is null OR oc.status = 'A' or oc.status = 'I')
1431: AND (r.status is null OR r.status = 'A' or r.status = 'I');

Line 1553: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

1549: AND oc.org_contact_id = p_org_contact_id
1550: AND oc.org_contact_id = d.RECORD_ID
1551: AND oc.party_relationship_id = r.relationship_id
1552: AND r.subject_id = pp.party_id
1553: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1554: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1555: AND DIRECTIONAL_FLAG= 'F'
1556: AND pp.effective_end_date is NULL
1557: AND (oc.status is null OR oc.status = 'A' or oc.status = 'I')

Line 1554: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'

1550: AND oc.org_contact_id = d.RECORD_ID
1551: AND oc.party_relationship_id = r.relationship_id
1552: AND r.subject_id = pp.party_id
1553: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1554: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1555: AND DIRECTIONAL_FLAG= 'F'
1556: AND pp.effective_end_date is NULL
1557: AND (oc.status is null OR oc.status = 'A' or oc.status = 'I')
1558: AND (r.status is null OR r.status = 'A' or r.status = 'I')

Line 1666: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

1662: SELECT r.object_id INTO l_party_id
1663: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r
1664: WHERE oc.org_contact_id = p_org_contact_id
1665: AND oc.party_relationship_id = r.relationship_id
1666: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1667: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1668: AND subject_type = 'PERSON'
1669: AND DIRECTIONAL_FLAG = 'F'
1670: AND (oc.status is null OR oc.status = 'A' or oc.status = 'I')

Line 1667: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'

1663: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r
1664: WHERE oc.org_contact_id = p_org_contact_id
1665: AND oc.party_relationship_id = r.relationship_id
1666: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1667: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1668: AND subject_type = 'PERSON'
1669: AND DIRECTIONAL_FLAG = 'F'
1670: AND (oc.status is null OR oc.status = 'A' or oc.status = 'I')
1671: AND (r.status is null OR r.status = 'A' or r.status = 'I') ;

Line 1687: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

1683: WHERE
1684: oc.org_contact_id = p_org_contact_id
1685: AND oc.party_relationship_id = r.relationship_id
1686: AND r.subject_id = pp.party_id
1687: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1688: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1689: AND DIRECTIONAL_FLAG = 'F'
1690: AND pp.effective_end_date is NULL
1691: AND (oc.status is null OR oc.status = 'A' or oc.status = 'I')

Line 1688: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'

1684: oc.org_contact_id = p_org_contact_id
1685: AND oc.party_relationship_id = r.relationship_id
1686: AND r.subject_id = pp.party_id
1687: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1688: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1689: AND DIRECTIONAL_FLAG = 'F'
1690: AND pp.effective_end_date is NULL
1691: AND (oc.status is null OR oc.status = 'A' or oc.status = 'I')
1692: AND (r.status is null OR r.status = 'A' or r.status = 'I')

Line 1827: AND cp.OWNER_TABLE_NAME = nvl(g.owner_table,'HZ_PARTIES')

1823: ,cp.STATUS
1824: ,cp.CONTACT_POINT_PURPOSE
1825: FROM HZ_DQM_STAGE_GT g,HZ_CONTACT_POINTS cp
1826: WHERE cp.owner_table_id = g.owner_id
1827: AND cp.OWNER_TABLE_NAME = nvl(g.owner_table,'HZ_PARTIES')
1828: AND (cp.status is null OR cp.status = 'A' or cp.status = 'I');
1829:
1830: BEGIN
1831: OPEN contact_pt_cur;

Line 2143: FROM HZ_PARTY_SITES ps, HZ_PARTIES p

2139:
2140: IF l_ot_table = 'HZ_PARTY_SITES' THEN
2141: SELECT p.party_id, ps.party_site_id, party_type
2142: INTO l_party_id1, l_party_site_id, l_party_type
2143: FROM HZ_PARTY_SITES ps, HZ_PARTIES p
2144: WHERE party_site_id = l_ot_id
2145: AND p.party_id = ps.party_id;
2146:
2147: IF l_party_type = 'PARTY_RELATIONSHIP' THEN

Line 2154: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

2150: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r
2151: WHERE r.party_id = l_party_id1
2152: AND r.relationship_id = oc.party_relationship_id
2153: AND r.directional_flag = 'F'
2154: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2155: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES';
2156: EXCEPTION
2157: WHEN NO_DATA_FOUND THEN
2158: RETURN;

Line 2155: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES';

2151: WHERE r.party_id = l_party_id1
2152: AND r.relationship_id = oc.party_relationship_id
2153: AND r.directional_flag = 'F'
2154: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2155: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES';
2156: EXCEPTION
2157: WHEN NO_DATA_FOUND THEN
2158: RETURN;
2159: END;

Line 2165: ELSIF l_ot_table = 'HZ_PARTIES' THEN

2161: l_party_id:=l_party_id1;
2162: l_org_contact_id:=NULL;
2163: END IF;
2164:
2165: ELSIF l_ot_table = 'HZ_PARTIES' THEN
2166: l_party_site_id := NULL;
2167: SELECT party_type INTO l_party_type
2168: FROM hz_parties
2169: WHERE party_id = l_ot_id;

Line 2168: FROM hz_parties

2164:
2165: ELSIF l_ot_table = 'HZ_PARTIES' THEN
2166: l_party_site_id := NULL;
2167: SELECT party_type INTO l_party_type
2168: FROM hz_parties
2169: WHERE party_id = l_ot_id;
2170:
2171: IF l_party_type <> 'PARTY_RELATIONSHIP' THEN
2172: l_party_id := l_ot_id;

Line 2181: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

2177: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r
2178: WHERE r.party_id = l_ot_id
2179: AND r.relationship_id = oc.party_relationship_id
2180: AND r.directional_flag = 'F'
2181: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2182: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES';
2183: EXCEPTION
2184: WHEN NO_DATA_FOUND THEN
2185: RETURN;

Line 2182: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES';

2178: WHERE r.party_id = l_ot_id
2179: AND r.relationship_id = oc.party_relationship_id
2180: AND r.directional_flag = 'F'
2181: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2182: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES';
2183: EXCEPTION
2184: WHEN NO_DATA_FOUND THEN
2185: RETURN;
2186: END;

Line 2748: FROM HZ_PARTY_SITES ps, HZ_PARTIES p

2744: l_org_contact_id := -1;
2745:
2746: BEGIN
2747: SELECT ps.party_id,p.party_type INTO l_party_id1, l_party_type
2748: FROM HZ_PARTY_SITES ps, HZ_PARTIES p
2749: WHERE party_site_id = p_party_site_id
2750: AND p.PARTY_ID = ps.PARTY_ID;
2751: -- take care of invalid party ids
2752: EXCEPTION

Line 2765: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

2761: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r
2762: WHERE r.party_id = l_party_id1
2763: AND r.relationship_id = oc.party_relationship_id
2764: AND r.directional_flag = 'F'
2765: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2766: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES';
2767: -- take care of invalid identifiers
2768: EXCEPTION
2769: WHEN NO_DATA_FOUND THEN

Line 2766: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES';

2762: WHERE r.party_id = l_party_id1
2763: AND r.relationship_id = oc.party_relationship_id
2764: AND r.directional_flag = 'F'
2765: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2766: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES';
2767: -- take care of invalid identifiers
2768: EXCEPTION
2769: WHEN NO_DATA_FOUND THEN
2770: -- dbms_output.put_line ( 'Exception caught in party_rel ');

Line 3002: FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op, HZ_DQM_SYNC_INTERFACE dsi

2998: ,op.SIC_CODE_TYPE
2999: ,p.CATEGORY_CODE
3000: ,p.REFERENCE_USE_FLAG
3001: ,op.CORPORATION_CLASS
3002: FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op, HZ_DQM_SYNC_INTERFACE dsi
3003: WHERE p.party_id = op.party_id
3004: AND p.party_id = dsi.party_id
3005: AND p.PARTY_TYPE = 'ORGANIZATION'
3006: AND dsi.entity = 'PARTY'

Line 3028: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe, HZ_DQM_SYNC_INTERFACE dsi

3024: ,NULL
3025: ,p.CATEGORY_CODE
3026: ,p.REFERENCE_USE_FLAG
3027: ,NULL
3028: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe, HZ_DQM_SYNC_INTERFACE dsi
3029: WHERE p.party_id = pe.party_id
3030: AND p.party_id = dsi.party_id
3031: AND p.PARTY_TYPE = 'PERSON'
3032: AND dsi.entity = 'PARTY'

Line 3054: FROM HZ_PARTIES p, HZ_DQM_SYNC_INTERFACE dsi

3050: ,NULL
3051: ,p.CATEGORY_CODE
3052: ,p.REFERENCE_USE_FLAG
3053: ,NULL
3054: FROM HZ_PARTIES p, HZ_DQM_SYNC_INTERFACE dsi
3055: WHERE p.party_id = dsi.party_id
3056: AND dsi.entity = 'PARTY'
3057: AND dsi.staged_flag = 'N'
3058: AND dsi.operation = p_operation

Line 3742: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

3738: WHERE oc.party_relationship_id = r.relationship_id
3739: AND dsi.record_id = oc.org_contact_id
3740: AND r.subject_id = pp.party_id
3741: AND r.subject_type = 'PERSON'
3742: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
3743: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
3744: AND DIRECTIONAL_FLAG = 'F'
3745: AND pp.effective_end_date is NULL
3746: AND dsi.entity = 'CONTACTS'

Line 3743: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'

3739: AND dsi.record_id = oc.org_contact_id
3740: AND r.subject_id = pp.party_id
3741: AND r.subject_type = 'PERSON'
3742: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
3743: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
3744: AND DIRECTIONAL_FLAG = 'F'
3745: AND pp.effective_end_date is NULL
3746: AND dsi.entity = 'CONTACTS'
3747: AND dsi.operation = p_operation

Line 4338: FROM HZ_PARTIES p, HZ_IMP_PARTIES_SG ps, HZ_IMP_BATCH_DETAILS bd

4334: ,op.SIC_CODE_TYPE
4335: ,p.CATEGORY_CODE
4336: ,p.REFERENCE_USE_FLAG
4337: ,op.CORPORATION_CLASS
4338: FROM HZ_PARTIES p, HZ_IMP_PARTIES_SG ps, HZ_IMP_BATCH_DETAILS bd
4339: ,HZ_ORGANIZATION_PROFILES op
4340: WHERE p.request_id = bd.main_conc_req_id
4341: AND bd.batch_id = ps.batch_id
4342: AND p.PARTY_TYPE = 'ORGANIZATION'

Line 4367: FROM HZ_PARTIES p, HZ_IMP_PARTIES_SG ps, HZ_IMP_BATCH_DETAILS bd

4363: ,NULL
4364: ,p.CATEGORY_CODE
4365: ,p.REFERENCE_USE_FLAG
4366: ,NULL
4367: FROM HZ_PARTIES p, HZ_IMP_PARTIES_SG ps, HZ_IMP_BATCH_DETAILS bd
4368: ,HZ_PERSON_PROFILES pe
4369: WHERE p.request_id = bd.main_conc_req_id
4370: AND bd.batch_id = ps.batch_id
4371: AND p.PARTY_TYPE = 'PERSON'

Line 4396: FROM HZ_PARTIES p, HZ_IMP_PARTIES_SG ps, HZ_IMP_BATCH_DETAILS bd

4392: ,NULL
4393: ,p.CATEGORY_CODE
4394: ,p.REFERENCE_USE_FLAG
4395: ,NULL
4396: FROM HZ_PARTIES p, HZ_IMP_PARTIES_SG ps, HZ_IMP_BATCH_DETAILS bd
4397: WHERE p.request_id = bd.main_conc_req_id
4398: AND bd.batch_id = ps.batch_id
4399: AND p.party_id = ps.party_id
4400: AND ps.batch_id = p_batch_id

Line 4490: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

4486: AND oc.request_id = bd.main_conc_req_id
4487: AND bd.batch_id = ocsg.batch_id
4488: AND r.subject_id = pp.party_id
4489: AND r.subject_type = 'PERSON'
4490: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4491: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4492: AND DIRECTIONAL_FLAG = 'F'
4493: AND ocsg.action_flag = p_operation
4494: AND pp.effective_end_date IS NULL

Line 4491: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'

4487: AND bd.batch_id = ocsg.batch_id
4488: AND r.subject_id = pp.party_id
4489: AND r.subject_type = 'PERSON'
4490: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4491: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4492: AND DIRECTIONAL_FLAG = 'F'
4493: AND ocsg.action_flag = p_operation
4494: AND pp.effective_end_date IS NULL
4495: AND ocsg.sub_orig_system_reference BETWEEN p_from_osr AND p_to_osr

Line 4522: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

4518: AND r.directional_flag = 'F'
4519: AND r.subject_id = pp.party_id
4520: AND r.subject_type = 'PERSON'
4521: AND r.object_type = 'ORGANIZATION'
4522: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4523: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4524: AND rsg.action_flag = p_operation
4525: AND pp.effective_end_date IS NULL
4526: AND rsg.sub_orig_system_reference BETWEEN p_from_osr AND p_to_osr

Line 4523: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'

4519: AND r.subject_id = pp.party_id
4520: AND r.subject_type = 'PERSON'
4521: AND r.object_type = 'ORGANIZATION'
4522: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4523: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4524: AND rsg.action_flag = p_operation
4525: AND pp.effective_end_date IS NULL
4526: AND rsg.sub_orig_system_reference BETWEEN p_from_osr AND p_to_osr
4527: AND (oc.status IS NULL OR oc.status = 'A' OR oc.status = 'I')