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 469: FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op

465: ,op.SIC_CODE_TYPE
466: ,p.CATEGORY_CODE
467: ,p.REFERENCE_USE_FLAG
468: ,op.CORPORATION_CLASS
469: FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op
470: WHERE mod(p.PARTY_ID, p_num_workers) = p_worker_number
471: AND p.party_id = op.party_id
472: AND op.effective_end_date is NULL
473: AND p.PARTY_TYPE ='ORGANIZATION';

Line 490: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe

486: ,NULL
487: ,p.CATEGORY_CODE
488: ,p.REFERENCE_USE_FLAG
489: ,NULL
490: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe
491: WHERE mod(p.PARTY_ID, p_num_workers) = p_worker_number
492: AND p.party_id = pe.party_id
493: AND pe.effective_end_date is NULL
494: AND p.PARTY_TYPE ='PERSON';

Line 511: FROM HZ_PARTIES p

507: ,NULL
508: ,p.CATEGORY_CODE
509: ,p.REFERENCE_USE_FLAG
510: ,NULL
511: FROM HZ_PARTIES p
512: WHERE mod(p.PARTY_ID, p_num_workers) = p_worker_number
513: AND p.party_type <> 'PERSON'
514: AND p.party_type <> 'ORGANIZATION'
515: AND p.party_type <> 'PARTY_RELATIONSHIP';

Line 534: FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op

530: ,op.SIC_CODE_TYPE
531: ,p.CATEGORY_CODE
532: ,p.REFERENCE_USE_FLAG
533: ,op.CORPORATION_CLASS
534: FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op
535: WHERE mod(p.PARTY_ID, p_num_workers) = p_worker_number
536: AND NOT EXISTS (select 1 FROM HZ_STAGED_PARTIES sp
537: WHERE sp.party_id = p.party_id)
538: AND p.party_id = op.party_id

Line 557: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe

553: ,NULL
554: ,p.CATEGORY_CODE
555: ,p.REFERENCE_USE_FLAG
556: ,NULL
557: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe
558: WHERE mod(p.PARTY_ID, p_num_workers) = p_worker_number
559: AND NOT EXISTS (select 1 FROM HZ_STAGED_PARTIES sp
560: WHERE sp.party_id = p.party_id)
561: AND p.party_id = pe.party_id

Line 580: FROM HZ_PARTIES p

576: ,NULL
577: ,p.CATEGORY_CODE
578: ,p.REFERENCE_USE_FLAG
579: ,NULL
580: FROM HZ_PARTIES p
581: WHERE mod(p.PARTY_ID, p_num_workers) = p_worker_number
582: AND NOT EXISTS (select 1 FROM HZ_STAGED_PARTIES sp
583: WHERE sp.party_id = p.party_id)
584: AND p.party_type <> 'PERSON'

Line 817: FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op

813: , H_TX47(1)
814: , H_TX48(1)
815: , H_TX156(1)
816: , H_TX157(1)
817: FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op
818: WHERE p.party_id = p_party_id
819: AND p.party_id = op.party_id
820: AND (p.status = 'M' or op.effective_end_date is NULL) AND ROWNUM=1;
821: ELSIF p_party_type = 'PERSON' THEN

Line 850: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe

846: , H_TX47(1)
847: , H_TX48(1)
848: , H_TX156(1)
849: , H_TX157(1)
850: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe
851: WHERE p.party_id = p_party_id
852: AND p.party_id = pe.party_id
853: AND (p.status = 'M' or pe.effective_end_date is NULL) AND ROWNUM=1;
854: ELSE

Line 883: FROM HZ_PARTIES p

879: , H_TX47(1)
880: , H_TX48(1)
881: , H_TX156(1)
882: , H_TX157(1)
883: FROM HZ_PARTIES p
884: WHERE p.party_id = p_party_id;
885: END IF;
886: H_TX32(1):=HZ_PARTY_ACQUIRE.get_account_info(H_P_PARTY_ID(1),'PARTY','ALL_ACCOUNT_NAMES', 'STAGE');
887: H_TX35(1):=HZ_PARTY_ACQUIRE.get_account_info(H_P_PARTY_ID(1),'PARTY','ALL_ACCOUNT_NUMBERS', 'STAGE');

Line 1065: AND pr.subject_table_name = 'HZ_PARTIES'

1061: SELECT oc.org_contact_id
1062: FROM HZ_RELATIONSHIPS pr, HZ_ORG_CONTACTS oc
1063: WHERE pr.relationship_id = oc.party_relationship_id
1064: AND pr.subject_id = p_party_id
1065: AND pr.subject_table_name = 'HZ_PARTIES'
1066: AND pr.object_table_name = 'HZ_PARTIES'
1067: AND pr.directional_flag = 'F';
1068:
1069: BEGIN

Line 1066: AND pr.object_table_name = 'HZ_PARTIES'

1062: FROM HZ_RELATIONSHIPS pr, HZ_ORG_CONTACTS oc
1063: WHERE pr.relationship_id = oc.party_relationship_id
1064: AND pr.subject_id = p_party_id
1065: AND pr.subject_table_name = 'HZ_PARTIES'
1066: AND pr.object_table_name = 'HZ_PARTIES'
1067: AND pr.directional_flag = 'F';
1068:
1069: BEGIN
1070:

Line 1073: FROM hz_parties WHERE party_id = p_party_id;

1069: BEGIN
1070:
1071: -- Get party_type
1072: SELECT party_type INTO l_party_type
1073: FROM hz_parties WHERE party_id = p_party_id;
1074:
1075: -- Set global G_PARTY_TYPE variable value
1076: hz_trans_pkg.set_party_type(l_party_type);
1077:

Line 1129: FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op

1125: , H_TX47(1)
1126: , H_TX48(1)
1127: , H_TX156(1)
1128: , H_TX157(1)
1129: FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op
1130: WHERE p.party_id = p_party_id
1131: AND p.party_id = op.party_id
1132: AND (p.status = 'M' or op.effective_end_date is NULL) AND ROWNUM=1;
1133: ELSIF l_party_type = 'PERSON' THEN

Line 1162: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe

1158: , H_TX47(1)
1159: , H_TX48(1)
1160: , H_TX156(1)
1161: , H_TX157(1)
1162: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe
1163: WHERE p.party_id = p_party_id
1164: AND p.party_id = pe.party_id
1165: AND (p.status = 'M' or pe.effective_end_date is NULL) AND ROWNUM=1;
1166: ELSE

Line 1195: FROM HZ_PARTIES p

1191: , H_TX47(1)
1192: , H_TX48(1)
1193: , H_TX156(1)
1194: , H_TX157(1)
1195: FROM HZ_PARTIES p
1196: WHERE p.party_id = p_party_id;
1197: END IF;
1198:
1199: H_TX32(1):=HZ_PARTY_ACQUIRE.get_account_info(H_P_PARTY_ID(1),'PARTY','ALL_ACCOUNT_NAMES', 'STAGE');

Line 1400: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

1396: HZ_ORG_CONTACTS oc, HZ_PERSON_PROFILES pp
1397: WHERE oc.party_relationship_id = r.relationship_id
1398: AND r.object_id = g.party_id
1399: AND r.subject_id = pp.party_id
1400: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1401: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1402: AND DIRECTIONAL_FLAG= 'F'
1403: AND pp.effective_end_date is NULL
1404: AND (oc.status is null OR oc.status = 'A' or oc.status = 'I')

Line 1401: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'

1397: WHERE oc.party_relationship_id = r.relationship_id
1398: AND r.object_id = g.party_id
1399: AND r.subject_id = pp.party_id
1400: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1401: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1402: AND DIRECTIONAL_FLAG= 'F'
1403: AND pp.effective_end_date is NULL
1404: AND (oc.status is null OR oc.status = 'A' or oc.status = 'I')
1405: AND (r.status is null OR r.status = 'A' or r.status = 'I');

Line 1527: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

1523: AND oc.org_contact_id = p_org_contact_id
1524: AND oc.org_contact_id = d.RECORD_ID
1525: AND oc.party_relationship_id = r.relationship_id
1526: AND r.subject_id = pp.party_id
1527: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1528: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1529: AND DIRECTIONAL_FLAG= 'F'
1530: AND pp.effective_end_date is NULL
1531: AND (oc.status is null OR oc.status = 'A' or oc.status = 'I')

Line 1528: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'

1524: AND oc.org_contact_id = d.RECORD_ID
1525: AND oc.party_relationship_id = r.relationship_id
1526: AND r.subject_id = pp.party_id
1527: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1528: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1529: AND DIRECTIONAL_FLAG= 'F'
1530: AND pp.effective_end_date is NULL
1531: AND (oc.status is null OR oc.status = 'A' or oc.status = 'I')
1532: AND (r.status is null OR r.status = 'A' or r.status = 'I')

Line 1640: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

1636: SELECT r.object_id INTO l_party_id
1637: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r
1638: WHERE oc.org_contact_id = p_org_contact_id
1639: AND oc.party_relationship_id = r.relationship_id
1640: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1641: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1642: AND subject_type = 'PERSON'
1643: AND DIRECTIONAL_FLAG = 'F'
1644: AND (oc.status is null OR oc.status = 'A' or oc.status = 'I')

Line 1641: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'

1637: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r
1638: WHERE oc.org_contact_id = p_org_contact_id
1639: AND oc.party_relationship_id = r.relationship_id
1640: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1641: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1642: AND subject_type = 'PERSON'
1643: AND DIRECTIONAL_FLAG = 'F'
1644: AND (oc.status is null OR oc.status = 'A' or oc.status = 'I')
1645: AND (r.status is null OR r.status = 'A' or r.status = 'I') ;

Line 1661: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

1657: WHERE
1658: oc.org_contact_id = p_org_contact_id
1659: AND oc.party_relationship_id = r.relationship_id
1660: AND r.subject_id = pp.party_id
1661: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1662: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1663: AND DIRECTIONAL_FLAG = 'F'
1664: AND pp.effective_end_date is NULL
1665: AND (oc.status is null OR oc.status = 'A' or oc.status = 'I')

Line 1662: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'

1658: oc.org_contact_id = p_org_contact_id
1659: AND oc.party_relationship_id = r.relationship_id
1660: AND r.subject_id = pp.party_id
1661: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1662: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1663: AND DIRECTIONAL_FLAG = 'F'
1664: AND pp.effective_end_date is NULL
1665: AND (oc.status is null OR oc.status = 'A' or oc.status = 'I')
1666: AND (r.status is null OR r.status = 'A' or r.status = 'I')

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

1797: ,cp.STATUS
1798: ,cp.CONTACT_POINT_PURPOSE
1799: FROM HZ_DQM_STAGE_GT g,HZ_CONTACT_POINTS cp
1800: WHERE cp.owner_table_id = g.owner_id
1801: AND cp.OWNER_TABLE_NAME = nvl(g.owner_table,'HZ_PARTIES')
1802: AND (cp.status is null OR cp.status = 'A' or cp.status = 'I');
1803:
1804: BEGIN
1805: OPEN contact_pt_cur;

Line 2117: FROM HZ_PARTY_SITES ps, HZ_PARTIES p

2113:
2114: IF l_ot_table = 'HZ_PARTY_SITES' THEN
2115: SELECT p.party_id, ps.party_site_id, party_type
2116: INTO l_party_id1, l_party_site_id, l_party_type
2117: FROM HZ_PARTY_SITES ps, HZ_PARTIES p
2118: WHERE party_site_id = l_ot_id
2119: AND p.party_id = ps.party_id;
2120:
2121: IF l_party_type = 'PARTY_RELATIONSHIP' THEN

Line 2128: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

2124: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r
2125: WHERE r.party_id = l_party_id1
2126: AND r.relationship_id = oc.party_relationship_id
2127: AND r.directional_flag = 'F'
2128: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2129: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES';
2130: EXCEPTION
2131: WHEN NO_DATA_FOUND THEN
2132: RETURN;

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

2125: WHERE r.party_id = l_party_id1
2126: AND r.relationship_id = oc.party_relationship_id
2127: AND r.directional_flag = 'F'
2128: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2129: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES';
2130: EXCEPTION
2131: WHEN NO_DATA_FOUND THEN
2132: RETURN;
2133: END;

Line 2139: ELSIF l_ot_table = 'HZ_PARTIES' THEN

2135: l_party_id:=l_party_id1;
2136: l_org_contact_id:=NULL;
2137: END IF;
2138:
2139: ELSIF l_ot_table = 'HZ_PARTIES' THEN
2140: l_party_site_id := NULL;
2141: SELECT party_type INTO l_party_type
2142: FROM hz_parties
2143: WHERE party_id = l_ot_id;

Line 2142: FROM hz_parties

2138:
2139: ELSIF l_ot_table = 'HZ_PARTIES' THEN
2140: l_party_site_id := NULL;
2141: SELECT party_type INTO l_party_type
2142: FROM hz_parties
2143: WHERE party_id = l_ot_id;
2144:
2145: IF l_party_type <> 'PARTY_RELATIONSHIP' THEN
2146: l_party_id := l_ot_id;

Line 2155: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

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

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

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

Line 2722: FROM HZ_PARTY_SITES ps, HZ_PARTIES p

2718: l_org_contact_id := -1;
2719:
2720: BEGIN
2721: SELECT ps.party_id,p.party_type INTO l_party_id1, l_party_type
2722: FROM HZ_PARTY_SITES ps, HZ_PARTIES p
2723: WHERE party_site_id = p_party_site_id
2724: AND p.PARTY_ID = ps.PARTY_ID;
2725: -- take care of invalid party ids
2726: EXCEPTION

Line 2739: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

2735: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r
2736: WHERE r.party_id = l_party_id1
2737: AND r.relationship_id = oc.party_relationship_id
2738: AND r.directional_flag = 'F'
2739: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2740: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES';
2741: -- take care of invalid identifiers
2742: EXCEPTION
2743: WHEN NO_DATA_FOUND THEN

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

2736: WHERE r.party_id = l_party_id1
2737: AND r.relationship_id = oc.party_relationship_id
2738: AND r.directional_flag = 'F'
2739: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2740: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES';
2741: -- take care of invalid identifiers
2742: EXCEPTION
2743: WHEN NO_DATA_FOUND THEN
2744: -- dbms_output.put_line ( 'Exception caught in party_rel ');

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

2972: ,op.SIC_CODE_TYPE
2973: ,p.CATEGORY_CODE
2974: ,p.REFERENCE_USE_FLAG
2975: ,op.CORPORATION_CLASS
2976: FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op, HZ_DQM_SYNC_INTERFACE dsi
2977: WHERE p.party_id = op.party_id
2978: AND p.party_id = dsi.party_id
2979: AND p.PARTY_TYPE = 'ORGANIZATION'
2980: AND dsi.entity = 'PARTY'

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

2998: ,NULL
2999: ,p.CATEGORY_CODE
3000: ,p.REFERENCE_USE_FLAG
3001: ,NULL
3002: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe, HZ_DQM_SYNC_INTERFACE dsi
3003: WHERE p.party_id = pe.party_id
3004: AND p.party_id = dsi.party_id
3005: AND p.PARTY_TYPE = 'PERSON'
3006: AND dsi.entity = 'PARTY'

Line 3028: FROM HZ_PARTIES p, HZ_DQM_SYNC_INTERFACE dsi

3024: ,NULL
3025: ,p.CATEGORY_CODE
3026: ,p.REFERENCE_USE_FLAG
3027: ,NULL
3028: FROM HZ_PARTIES p, HZ_DQM_SYNC_INTERFACE dsi
3029: WHERE p.party_id = dsi.party_id
3030: AND dsi.entity = 'PARTY'
3031: AND dsi.staged_flag = 'N'
3032: AND dsi.operation = p_operation

Line 3716: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

3712: WHERE oc.party_relationship_id = r.relationship_id
3713: AND dsi.record_id = oc.org_contact_id
3714: AND r.subject_id = pp.party_id
3715: AND r.subject_type = 'PERSON'
3716: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
3717: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
3718: AND DIRECTIONAL_FLAG = 'F'
3719: AND pp.effective_end_date is NULL
3720: AND dsi.entity = 'CONTACTS'

Line 3717: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'

3713: AND dsi.record_id = oc.org_contact_id
3714: AND r.subject_id = pp.party_id
3715: AND r.subject_type = 'PERSON'
3716: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
3717: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
3718: AND DIRECTIONAL_FLAG = 'F'
3719: AND pp.effective_end_date is NULL
3720: AND dsi.entity = 'CONTACTS'
3721: AND dsi.operation = p_operation

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

4308: ,op.SIC_CODE_TYPE
4309: ,p.CATEGORY_CODE
4310: ,p.REFERENCE_USE_FLAG
4311: ,op.CORPORATION_CLASS
4312: FROM HZ_PARTIES p, HZ_IMP_PARTIES_SG ps, HZ_IMP_BATCH_DETAILS bd
4313: ,HZ_ORGANIZATION_PROFILES op
4314: WHERE p.request_id = bd.main_conc_req_id
4315: AND bd.batch_id = ps.batch_id
4316: AND p.PARTY_TYPE = 'ORGANIZATION'

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

4337: ,NULL
4338: ,p.CATEGORY_CODE
4339: ,p.REFERENCE_USE_FLAG
4340: ,NULL
4341: FROM HZ_PARTIES p, HZ_IMP_PARTIES_SG ps, HZ_IMP_BATCH_DETAILS bd
4342: ,HZ_PERSON_PROFILES pe
4343: WHERE p.request_id = bd.main_conc_req_id
4344: AND bd.batch_id = ps.batch_id
4345: AND p.PARTY_TYPE = 'PERSON'

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

4366: ,NULL
4367: ,p.CATEGORY_CODE
4368: ,p.REFERENCE_USE_FLAG
4369: ,NULL
4370: FROM HZ_PARTIES p, HZ_IMP_PARTIES_SG ps, HZ_IMP_BATCH_DETAILS bd
4371: WHERE p.request_id = bd.main_conc_req_id
4372: AND bd.batch_id = ps.batch_id
4373: AND p.party_id = ps.party_id
4374: AND ps.batch_id = p_batch_id

Line 4464: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

4460: AND oc.request_id = bd.main_conc_req_id
4461: AND bd.batch_id = ocsg.batch_id
4462: AND r.subject_id = pp.party_id
4463: AND r.subject_type = 'PERSON'
4464: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4465: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4466: AND DIRECTIONAL_FLAG = 'F'
4467: AND ocsg.action_flag = p_operation
4468: AND pp.effective_end_date IS NULL

Line 4465: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'

4461: AND bd.batch_id = ocsg.batch_id
4462: AND r.subject_id = pp.party_id
4463: AND r.subject_type = 'PERSON'
4464: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4465: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4466: AND DIRECTIONAL_FLAG = 'F'
4467: AND ocsg.action_flag = p_operation
4468: AND pp.effective_end_date IS NULL
4469: AND ocsg.sub_orig_system_reference BETWEEN p_from_osr AND p_to_osr

Line 4496: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

4492: AND r.directional_flag = 'F'
4493: AND r.subject_id = pp.party_id
4494: AND r.subject_type = 'PERSON'
4495: AND r.object_type = 'ORGANIZATION'
4496: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4497: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4498: AND rsg.action_flag = p_operation
4499: AND pp.effective_end_date IS NULL
4500: AND rsg.sub_orig_system_reference BETWEEN p_from_osr AND p_to_osr

Line 4497: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'

4493: AND r.subject_id = pp.party_id
4494: AND r.subject_type = 'PERSON'
4495: AND r.object_type = 'ORGANIZATION'
4496: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4497: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4498: AND rsg.action_flag = p_operation
4499: AND pp.effective_end_date IS NULL
4500: AND rsg.sub_orig_system_reference BETWEEN p_from_osr AND p_to_osr
4501: AND (oc.status IS NULL OR oc.status = 'A' OR oc.status = 'I')