APPS.CSC_PROFILE_ENGINE_PKG dependencies on HZ_PARTIES

Line 617: FROM hz_parties hz

613: SELECT party_id,
614: NULL,
615: NULL, -- Added by spamujul for ER#8473903
616: NULL
617: FROM hz_parties hz
618: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c
619: WHERE c.party_id = hz.party_id
620: AND C.PARTY_SITE_ID IS NULL -- Added by spamujul for ER#8473903
621: )

Line 634: FROM hz_parties hz

630: SELECT party_id,
631: NULL,
632: NULL, -- Added 'NULL' for party_site_id by spamujul for ER#8473903
633: NULL
634: FROM hz_parties hz
635: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c
636: WHERE c.party_id = hz.party_id
637: AND C.PARTY_SITE_ID IS NULL -- Added by spamujul for ER#8473903
638: )

Line 1018: FROM hz_parties

1014: AND Nvl(end_date_active, SYSDATE);
1015:
1016: CURSOR cparty_csr IS
1017: SELECT party_id
1018: FROM hz_parties
1019: WHERE status = 'A'
1020: AND PARTY_TYPE IN ('PERSON','ORGANIZATION');
1021: -- Person, ORG added for 1850508
1022:

Line 1474: FROM hz_parties

1470: AND select_type = 'T';
1471:
1472: CURSOR cparty_csr IS
1473: SELECT party_id
1474: FROM hz_parties
1475: WHERE status = 'A'
1476: AND PARTY_TYPE IN ('PERSON','ORGANIZATION');
1477: -- Person, ORG added for 1850508
1478:

Line 2412: FROM hz_parties

2408: AND a.critical_flag = 'Y');
2409:
2410: CURSOR rel_party_csr(c_party_id IN NUMBER) IS
2411: SELECT 1
2412: FROM hz_parties
2413: WHERE party_id = c_party_id
2414: AND party_type = 'PARTY_RELATIONSHIP'
2415: AND status = 'A';
2416:

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

2522: CALL Evaluate_Checks2_JIT;
2523: END IF;
2524:
2525: */
2526: /* Bug 5168090 Fix - scenario where employee_id and party_id from hz_parties have the same value */
2527: IF g_dashboard_for_employee = 'Y' THEN
2528: l_emp_refresh := 'Y';
2529: ELSE
2530: OPEN rel_party_csr(p_party_id);

Line 2841: SELECT party_id FROM hz_parties

2837: AND sysdate between nvl(a.start_date_active,sysdate)
2838: AND nvl(a.end_date_active,sysdate));
2839:
2840: CURSOR crelparty_csr(c_party_id IN NUMBER) IS
2841: SELECT party_id FROM hz_parties
2842: WHERE party_id = c_party_id
2843: AND party_type = 'PARTY_RELATIONSHIP'
2844: AND status = 'A';
2845:

Line 3862: FROM hz_parties hz

3858: ACCOUNT_ID,
3859: PARTY_SITE_ID, --Included party_site_id for ER#8473903
3860: VALUE)
3861: SELECT party_id, NULL, NULL,NULL -- Included NULL for party_site_id for ER#8473903
3862: FROM hz_parties hz
3863: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.party_id)
3864: AND hz.status = 'A'
3865: AND hz.party_type IN ('PERSON', 'ORGANIZATION');
3866: ELSIF v_check_level = 'CONTACT' THEN

Line 3872: FROM hz_parties hz

3868: ACCOUNT_ID,
3869: PARTY_SITE_ID, --Included party_site_id for ER#8473903
3870: VALUE)
3871: SELECT party_id, NULL, NULL ,NULL -- Included NULL for party_site_id for ER#8473903
3872: FROM hz_parties hz
3873: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.party_id)
3874: AND hz.status = 'A'
3875: AND hz.party_type = 'PARTY_RELATIONSHIP';
3876: ELSIF v_check_level = 'ACCOUNT' THEN

Line 4241: FROM hz_parties

4237: AND Nvl(end_date_active, SYSDATE);
4238:
4239: CURSOR cparty_csr IS
4240: SELECT party_id
4241: FROM hz_parties
4242: WHERE status = 'A'
4243: AND PARTY_TYPE IN ('PERSON','ORGANIZATION');
4244: -- Person, ORG added for 1850508
4245:

Line 4687: FROM hz_parties

4683: AND Nvl(end_date_active, Sysdate)
4684: AND select_type = 'T';
4685: CURSOR cparty_csr IS
4686: SELECT party_id
4687: FROM hz_parties
4688: WHERE status = 'A'
4689: AND PARTY_TYPE IN ('PERSON','ORGANIZATION');
4690: -- Person, ORG added for 1850508
4691: /* added this condition party_id=v_party_id for Bug 1937730*/

Line 5837: FROM hz_parties

5833: );
5834: -- cursor to update all results of a party
5835: CURSOR bparty_csr IS
5836: SELECT party_id
5837: FROM hz_parties
5838: WHERE status='A'
5839: AND PARTY_TYPE IN ('PERSON','ORGANIZATION');
5840: -- Person, ORG added for 1850508
5841:

Line 6135: FROM hz_parties

6131:
6132: -- cursor to update all results of a party
6133: CURSOR bparty_csr IS
6134: SELECT party_id
6135: FROM hz_parties
6136: WHERE status='A'
6137: AND PARTY_TYPE IN ('PERSON','ORGANIZATION');
6138:
6139: -- cursor to update all results of an account

Line 6727: FROM hz_parties

6723: ;
6724: -- cursor to update all results of a party
6725: CURSOR bparty_csr IS
6726: SELECT party_id
6727: FROM hz_parties
6728: WHERE status='A'
6729: AND PARTY_TYPE IN ('PERSON','ORGANIZATION');
6730: -- Person, ORG added for 1850508
6731: /* added this condition party_id=v_party_id for Bug 1937730*/

Line 7015: FROM hz_parties

7011:
7012: -- cursor to update all results of a party
7013: CURSOR bparty_csr IS
7014: SELECT party_id
7015: FROM hz_parties
7016: WHERE status='A'
7017: AND PARTY_TYPE IN ('PERSON','ORGANIZATION');
7018:
7019: -- cursor to update all results of an account

Line 7453: FROM hz_parties

7449: v_rec_var r_blk_rectype;
7450:
7451: CURSOR relparty_csr IS
7452: SELECT party_id
7453: FROM hz_parties
7454: WHERE status='A'
7455: AND PARTY_TYPE = 'PARTY_RELATIONSHIP';
7456: -- Begin fix by spamujul for ER#8473903
7457: CURSOR bpsite_csr IS

Line 7766: FROM hz_parties

7762: WHERE a.block_id = sel_blk_id;
7763:
7764: CURSOR crelparty_csr IS
7765: SELECT party_id
7766: FROM hz_parties
7767: WHERE status='A'
7768: AND party_type = 'PARTY_RELATIONSHIP';
7769: -- Begin fix by spamujul for ER#8473903
7770: CURSOR cpsite_csr IS

Line 9608: FROM hz_parties

9604: ORDER BY a.party_type desc, a.responsibility_id;
9605:
9606: CURSOR get_party_type IS
9607: SELECT party_type
9608: FROM hz_parties
9609: WHERE party_id = l_party_id;
9610:
9611: CURSOR get_acct_latest IS
9612: SELECT cust_account_id

Line 9631: FROM csc_hz_parties_rel_v

9627: ORDER BY creation_date;
9628:
9629: CURSOR get_cust_from_cont IS
9630: SELECT obj_party_id, obj_party_type
9631: FROM csc_hz_parties_rel_v
9632: WHERE rel_party_id = l_party_id;
9633:
9634: BEGIN
9635: IF FND_API.to_Boolean( p_init_msg_list ) THEN