eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_ENRQ_BINS_PVT dependencies on PV_PARTNER_PROGRAM_TYPE_B

Line 165: FROM pv_partner_program_type_b pvpptb

161: ,pvppb.global_mmbr_reqd_flag global_mmbr_reqd_flag
162: ,pvppb.prereq_process_rule_id prereq_process_rule_id
163: ,pvppb.no_fee_flag no_fee_flag
164: ,pvppb.vad_invite_allow_flag vad_invite_allow_flag
165: FROM pv_partner_program_type_b pvpptb
166: ,pv_partner_program_vl pvppb
167: WHERE pvppb.program_status_code = 'ACTIVE'
168: AND pvppb.program_level_code ='MEMBERSHIP'
169: AND pvppb.enabled_flag = 'Y'

Line 230: FROM pv_partner_program_type_b pvpptb ,pv_partner_program_vl pvppb

226: ,pvppb.global_mmbr_reqd_flag global_mmbr_reqd_flag
227: ,pvppb.prereq_process_rule_id prereq_process_rule_id
228: ,pvppb.no_fee_flag no_fee_flag
229: ,pvppb.vad_invite_allow_flag vad_invite_allow_flag
230: FROM pv_partner_program_type_b pvpptb ,pv_partner_program_vl pvppb
231: WHERE pvppb.program_status_code = 'ACTIVE'
232: AND pvppb.program_level_code ='MEMBERSHIP'
233: AND pvppb.enabled_flag = 'Y'
234: AND nvl(pvppb.allow_enrl_until_date, sysdate) > sysdate-1

Line 512: FROM pv_partner_program_type_b pvpptb

508: ,memb.membership_id membership_id
509: ,memb.membership_status_code membership_status_code
510: ,memb.original_end_date original_end_date
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'

Line 808: ,pv_partner_program_type_b pvpptb

804: ,pvppb.vad_invite_allow_flag vad_invite_allow_flag
805: FROM pv_pg_enrl_change_rules rules
806: ,pv_pg_memberships memb
807: ,pv_partner_program_vl pvppb
808: ,pv_partner_program_type_b pvpptb
809:
810: WHERE pvppb.program_status_code = 'ACTIVE'
811: AND pvppb.program_level_code ='MEMBERSHIP'
812: AND pvppb.enabled_flag = 'Y'

Line 1083: FROM pv_partner_program_type_b pvpptb

1079: ,pvppb.global_mmbr_reqd_flag
1080: ,pvppb.prereq_process_rule_id prereq_process_rule_id
1081: ,pvppb.no_fee_flag no_fee_flag
1082: ,pvppb.vad_invite_allow_flag vad_invite_allow_flag
1083: FROM pv_partner_program_type_b pvpptb
1084: ,pv_partner_program_vl pvppb
1085: ,pv_pg_enrl_requests enrq
1086: WHERE pvppb.program_status_code = 'ACTIVE'
1087: AND pvppb.program_level_code ='MEMBERSHIP'

Line 1437: FROM pv_partner_program_type_b pvpptb

1433: AND latest_flag='Y';
1434:
1435: CURSOR isElig( ptnr_id NUMBER, p_prgm_id NUMBER ) IS
1436: SELECT 'Y' , global_mmbr_reqd_flag
1437: FROM pv_partner_program_type_b pvpptb
1438: , pv_partner_program_b pvppb
1439: WHERE program_id=p_prgm_id
1440: AND nvl(allow_enrl_until_date, sysdate) > sysdate-1
1441: AND pvppb.program_type_id = pvpptb.program_type_ID

Line 1484: , pv_partner_program_type_b pvpptb

1480: , global_mmbr_reqd_flag
1481: FROM pv_pg_enrl_change_rules rules
1482: , pv_pg_memberships memb
1483: , pv_partner_program_vl pvppb
1484: , pv_partner_program_type_b pvpptb
1485: WHERE pvppb.program_status_code = 'ACTIVE'
1486: AND pvppb.program_level_code ='MEMBERSHIP'
1487: AND pvppb.enabled_flag = 'Y'
1488: AND pvppb.program_id=p_to_id