APPS.CSC_PROFILE_ENGINE_PKG dependencies on PER_WORKFORCE_CURRENT_X

Line 668: FROM per_workforce_current_x hz

664: SELECT person_id,
665: NULL,
666: NULL , -- Added 'NULL' for party_site_id by spamujul for ER#8473903
667: NULL
668: FROM per_workforce_current_x hz
669: WHERE NOT EXISTS (SELECT 1
670: FROM CSC_PROF_BATCH_RESULTS1_T c
671: WHERE c.party_id = hz.person_id
672: AND C.PARTY_SITE_ID IS NULL -- Added by spamujul for ER#8473903

Line 2419: FROM per_workforce_current_x

2415: AND status = 'A';
2416:
2417: CURSOR employee_csr(c_party_id IN NUMBER) IS
2418: SELECT 1
2419: FROM per_workforce_current_x
2420: WHERE person_id = c_party_id;
2421:
2422:
2423: CURSOR rel_checks_csr IS

Line 3888: FROM per_workforce_current_x hz

3884: AND hz.status = 'A';
3885: ELSIF v_check_level = 'EMPLOYEE' THEN
3886: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,PARTY_SITE_ID,VALUE) --Included party_site_id for ER#8473903
3887: SELECT person_id, NULL, NULL,NULL -- Included NULL for party_site_id for ER#8473903
3888: FROM per_workforce_current_x hz
3889: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.person_id) ;
3890: -- Begin fix by spamujul for ER#8473903
3891: ELSIF v_check_level = 'SITE' THEN
3892: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,

Line 8164: FROM per_workforce_current_x;

8160: v_rec_var r_blk_rectype;
8161:
8162: CURSOR employee_csr IS
8163: SELECT person_id
8164: FROM per_workforce_current_x;
8165: cid number;
8166: val VARCHAR2(240) := null;
8167: BEGIN
8168: BEGIN

Line 8392: FROM per_workforce_current_x;

8388: WHERE a.block_id = sel_blk_id;
8389:
8390: CURSOR employee_csr IS
8391: SELECT person_id
8392: FROM per_workforce_current_x;
8393:
8394:
8395: cid number;
8396: val VARCHAR2(240) := null;