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_VL

Line 166: ,pv_partner_program_vl pvppb

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'
170: AND nvl(pvppb.allow_enrl_until_date, sysdate) > sysdate-1

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 513: ,pv_partner_program_vl pvppb

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'
517: AND pvppb.program_level_code ='MEMBERSHIP'

Line 807: ,pv_partner_program_vl pvppb

803: ,pvppb.no_fee_flag no_fee_flag
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'

Line 1084: ,pv_partner_program_vl pvppb

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'
1088: AND pvppb.enabled_flag = 'Y'

Line 1483: , pv_partner_program_vl pvppb

1479: SELECT 'Y'
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'