[Home] [Help]
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';
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
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
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
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'
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'
4343: AND p.party_id = ps.party_id