APPS.CSC_PROFILE_ENGINE_PKG dependencies on HZ_PARTIES

Line 569: FROM hz_parties hz

565:
566: IF v_check_level = 'PARTY' THEN
567: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)
568: SELECT party_id, NULL, NULL
569: FROM hz_parties hz
570: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.party_id)
571: AND hz.status = 'A'
572: AND hz.party_type IN ('PERSON', 'ORGANIZATION');
573: ELSIF v_check_level = 'CONTACT' THEN

Line 576: FROM hz_parties hz

572: AND hz.party_type IN ('PERSON', 'ORGANIZATION');
573: ELSIF v_check_level = 'CONTACT' THEN
574: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)
575: SELECT party_id, NULL, NULL
576: FROM hz_parties hz
577: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.party_id)
578: AND hz.status = 'A'
579: AND hz.party_type = 'PARTY_RELATIONSHIP';
580: ELSIF v_check_level = 'ACCOUNT' THEN

Line 847: FROM hz_parties

843: AND Nvl(end_date_active, SYSDATE);
844:
845: CURSOR cparty_csr IS
846: SELECT party_id
847: FROM hz_parties
848: WHERE status = 'A'
849: AND PARTY_TYPE IN ('PERSON','ORGANIZATION');
850: -- Person, ORG added for 1850508
851:

Line 1156: FROM hz_parties

1152: AND select_type = 'T';
1153:
1154: CURSOR cparty_csr IS
1155: SELECT party_id
1156: FROM hz_parties
1157: WHERE status = 'A'
1158: AND PARTY_TYPE IN ('PERSON','ORGANIZATION');
1159: -- Person, ORG added for 1850508
1160:

Line 1729: FROM hz_parties

1725: AND a.critical_flag = 'Y');
1726:
1727: CURSOR rel_party_csr(c_party_id IN NUMBER) IS
1728: SELECT 1
1729: FROM hz_parties
1730: WHERE party_id = c_party_id
1731: AND party_type = 'PARTY_RELATIONSHIP'
1732: AND status = 'A';
1733:

Line 1817: /* Bug 5168090 Fix - scenario where employee_id and party_id from hz_parties have the same value */

1813: END IF;
1814:
1815: */
1816:
1817: /* Bug 5168090 Fix - scenario where employee_id and party_id from hz_parties have the same value */
1818: IF g_dashboard_for_employee = 'Y' THEN
1819: l_emp_refresh := 'Y';
1820: ELSE
1821: OPEN rel_party_csr(p_party_id);

Line 2106: SELECT party_id FROM hz_parties

2102: AND sysdate between nvl(a.start_date_active,sysdate)
2103: AND nvl(a.end_date_active,sysdate));
2104:
2105: CURSOR crelparty_csr(c_party_id IN NUMBER) IS
2106: SELECT party_id FROM hz_parties
2107: WHERE party_id = c_party_id
2108: AND party_type = 'PARTY_RELATIONSHIP'
2109: AND status = 'A';
2110:

Line 2752: FROM hz_parties hz

2748:
2749: IF v_check_level = 'PARTY' THEN
2750: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)
2751: SELECT party_id, NULL, NULL
2752: FROM hz_parties hz
2753: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.party_id)
2754: AND hz.status = 'A'
2755: AND hz.party_type IN ('PERSON', 'ORGANIZATION');
2756: ELSIF v_check_level = 'CONTACT' THEN

Line 2759: FROM hz_parties hz

2755: AND hz.party_type IN ('PERSON', 'ORGANIZATION');
2756: ELSIF v_check_level = 'CONTACT' THEN
2757: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)
2758: SELECT party_id, NULL, NULL
2759: FROM hz_parties hz
2760: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.party_id)
2761: AND hz.status = 'A'
2762: AND hz.party_type = 'PARTY_RELATIONSHIP';
2763: ELSIF v_check_level = 'ACCOUNT' THEN

Line 3040: FROM hz_parties

3036: AND Nvl(end_date_active, SYSDATE);
3037:
3038: CURSOR cparty_csr IS
3039: SELECT party_id
3040: FROM hz_parties
3041: WHERE status = 'A'
3042: AND PARTY_TYPE IN ('PERSON','ORGANIZATION');
3043: -- Person, ORG added for 1850508
3044:

Line 3355: FROM hz_parties

3351: AND select_type = 'T';
3352:
3353: CURSOR cparty_csr IS
3354: SELECT party_id
3355: FROM hz_parties
3356: WHERE status = 'A'
3357: AND PARTY_TYPE IN ('PERSON','ORGANIZATION');
3358: -- Person, ORG added for 1850508
3359:

Line 4235: FROM hz_parties

4231:
4232: -- cursor to update all results of a party
4233: CURSOR bparty_csr IS
4234: SELECT party_id
4235: FROM hz_parties
4236: WHERE status='A'
4237: AND PARTY_TYPE IN ('PERSON','ORGANIZATION');
4238: -- Person, ORG added for 1850508
4239:

Line 4434: FROM hz_parties

4430:
4431: -- cursor to update all results of a party
4432: CURSOR bparty_csr IS
4433: SELECT party_id
4434: FROM hz_parties
4435: WHERE status='A'
4436: AND PARTY_TYPE IN ('PERSON','ORGANIZATION');
4437:
4438: -- cursor to update all results of an account

Line 4801: FROM hz_parties

4797:
4798: -- cursor to update all results of a party
4799: CURSOR bparty_csr IS
4800: SELECT party_id
4801: FROM hz_parties
4802: WHERE status='A'
4803: AND PARTY_TYPE IN ('PERSON','ORGANIZATION');
4804: -- Person, ORG added for 1850508
4805:

Line 5006: FROM hz_parties

5002:
5003: -- cursor to update all results of a party
5004: CURSOR bparty_csr IS
5005: SELECT party_id
5006: FROM hz_parties
5007: WHERE status='A'
5008: AND PARTY_TYPE IN ('PERSON','ORGANIZATION');
5009:
5010: -- cursor to update all results of an account

Line 5242: FROM hz_parties

5238: v_rec_var r_blk_rectype;
5239:
5240: CURSOR relparty_csr IS
5241: SELECT party_id
5242: FROM hz_parties
5243: WHERE status='A'
5244: AND PARTY_TYPE = 'PARTY_RELATIONSHIP';
5245:
5246: cid number;

Line 5461: FROM hz_parties

5457: WHERE a.block_id = sel_blk_id;
5458:
5459: CURSOR crelparty_csr IS
5460: SELECT party_id
5461: FROM hz_parties
5462: WHERE status='A'
5463: AND party_type = 'PARTY_RELATIONSHIP';
5464:
5465: cid number;

Line 6875: FROM hz_parties

6871: ORDER BY a.party_type desc, a.responsibility_id;
6872:
6873: CURSOR get_party_type IS
6874: SELECT party_type
6875: FROM hz_parties
6876: WHERE party_id = l_party_id;
6877:
6878: CURSOR get_acct_latest IS
6879: SELECT cust_account_id

Line 6898: FROM csc_hz_parties_rel_v

6894: ORDER BY creation_date;
6895:
6896: CURSOR get_cust_from_cont IS
6897: SELECT obj_party_id, obj_party_type
6898: FROM csc_hz_parties_rel_v
6899: WHERE rel_party_id = l_party_id;
6900:
6901: BEGIN
6902: IF FND_API.to_Boolean( p_init_msg_list ) THEN