APPS.CSC_PROFILE_ENGINE_PKG dependencies on PER_WORKFORCE_CURRENT_X

Line 589: FROM per_workforce_current_x hz

585: AND hz.status = 'A';
586: ELSIF v_check_level = 'EMPLOYEE' THEN
587: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)
588: SELECT person_id, NULL, NULL
589: FROM per_workforce_current_x hz
590: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.person_id) ;
591:
592: END IF;
593:

Line 1736: FROM per_workforce_current_x

1732: AND status = 'A';
1733:
1734: CURSOR employee_csr(c_party_id IN NUMBER) IS
1735: SELECT 1
1736: FROM per_workforce_current_x
1737: WHERE person_id = c_party_id;
1738:
1739:
1740: CURSOR rel_checks_csr IS

Line 2772: FROM per_workforce_current_x hz

2768: AND hz.status = 'A';
2769: ELSIF v_check_level = 'EMPLOYEE' THEN
2770: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)
2771: SELECT person_id, NULL, NULL
2772: FROM per_workforce_current_x hz
2773: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.person_id) ;
2774:
2775: END IF;
2776:

Line 5703: FROM per_workforce_current_x;

5699: v_rec_var r_blk_rectype;
5700:
5701: CURSOR employee_csr IS
5702: SELECT person_id
5703: FROM per_workforce_current_x;
5704:
5705:
5706: cid number;
5707: val VARCHAR2(240) := null;

Line 5922: FROM per_workforce_current_x;

5918: WHERE a.block_id = sel_blk_id;
5919:
5920: CURSOR employee_csr IS
5921: SELECT person_id
5922: FROM per_workforce_current_x;
5923:
5924:
5925: cid number;
5926: val VARCHAR2(240) := null;