APPS.PV_ENRQ_BINS_PVT dependencies on PV_PG_INVITE_HEADERS_B

Line 39: FROM PV_PG_INVITE_HEADERS_b

35: l_invite_header_id NUMBER:=null ;
36:
37: CURSOR rec_cur(p_ptr_id number,p_prgm_id number,p_inv_type_code VARCHAR2) IS
38: SELECT max(invite_header_id)
39: FROM PV_PG_INVITE_HEADERS_b
40: WHERE partner_id=p_ptr_id
41: AND nvl(invite_end_date,sysdate+1)>sysdate
42: AND invite_for_program_id =p_prgm_id
43: AND invite_type_code =p_inv_type_code;

Line 515: -- ,pv_pg_invite_headers_b inv

511: -- ,inv.invite_header_id invite_header_id
512: FROM pv_partner_program_type_b pvpptb
513: ,pv_partner_program_vl pvppb
514: ,pv_pg_memberships memb
515: -- ,pv_pg_invite_headers_b inv
516: WHERE pvppb.program_status_code = 'ACTIVE'
517: AND pvppb.program_level_code ='MEMBERSHIP'
518: AND pvppb.enabled_flag = 'Y'
519: AND nvl(pvppb.allow_enrl_until_date, sysdate) > sysdate-1