APPS.PV_PARTNER_PROGRAM_PVT dependencies on PV_PROCESS_RULES_VL

Line 2921: FROM pv_process_rules_vl pvprv

2917:
2918: l_process_type VARCHAR2(4000) := 'PARTNER_PROGRAM';
2919: CURSOR c_pr_exists IS
2920: SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1
2921: FROM pv_process_rules_vl pvprv
2922: WHERE PROCESS_RULE_ID = p_ptr_prgm_rec.process_rule_id
2923: AND NVL(start_date,SYSDATE) <= SYSDATE and NVL(end_date,SYSDATE) >= SYSDATE AND PROCESS_TYPE = l_process_type);
2924:
2925: CURSOR c_pr_exists_1 IS

Line 2927: FROM pv_process_rules_vl pvprv

2923: AND NVL(start_date,SYSDATE) <= SYSDATE and NVL(end_date,SYSDATE) >= SYSDATE AND PROCESS_TYPE = l_process_type);
2924:
2925: CURSOR c_pr_exists_1 IS
2926: SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1
2927: FROM pv_process_rules_vl pvprv
2928: WHERE PROCESS_RULE_ID = p_ptr_prgm_rec.prereq_process_rule_id
2929: AND NVL(start_date,SYSDATE) <= SYSDATE and NVL(end_date,SYSDATE) >= SYSDATE AND PROCESS_TYPE = l_process_type);
2930:
2931: l_resource_exists NUMBER := NULL;

Line 4483: FROM PV_PROCESS_RULES_VL

4479: WHERE program_id = cv_program_id;
4480:
4481: CURSOR c_get_process_rule_rec (cv_process_rule_id IN NUMBER) IS
4482: SELECT *
4483: FROM PV_PROCESS_RULES_VL
4484: WHERE PROCESS_RULE_ID = cv_process_rule_id;
4485:
4486: CURSOR c_get_program_name_rec (cv_program_id IN NUMBER) IS
4487: SELECT program_name