APPS.PV_PRGM_APPROVAL_PVT dependencies on PV_PG_ENRQ_INIT_SOURCES

Line 341: FROM pv_pg_memberships memb,pv_pg_enrq_init_sources eni

337:
338: l_memb_type VARCHAR2(30);
339: CURSOR prev_memb_date_cur(p_enrl_req_id number) IS
340: SELECT nvl(actual_end_date,original_end_date) prev_end_date
341: FROM pv_pg_memberships memb,pv_pg_enrq_init_sources eni
342: WHERE eni.prev_membership_id=memb.membership_id
343: AND eni.enrl_request_id=p_enrl_req_id;
344:
345: CURSOR enr_requests_dtl_cur (p_enrl_req_id number) IS

Line 2562: FROM pv_pg_enrq_init_sources

2558: WHERE membership_id=p_membership_id;
2559:
2560: CURSOR prev_memb_id_cur(p_enrl_req_id number) IS
2561: SELECT prev_membership_id
2562: FROM pv_pg_enrq_init_sources
2563: WHERE enrl_request_id=p_enrl_req_id;
2564:
2565: /**
2566: CURSOR check_attr_exist(p_program_id NUMBER) IS