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_PG_MEMBERSHIPS_PVT dependencies on PV_PARTNER_PROGRAM_B

Line 2359: ,pv_partner_program_b pvpp,

2355:
2356: CURSOR mmbr_transitions_csr(to_mmbr_id NUMBER) IS
2357: SELECT memb.program_id program_id,trn.lvl actlevel
2358: FROM pv_pg_memberships memb
2359: ,pv_partner_program_b pvpp,
2360: (
2361:
2362: SELECT from_membership_id,min(level) lvl
2363: FROM pv_pg_mmbr_transitions

Line 2376: ,pv_partner_program_b pvpp

2372:
2373: CURSOR prg_csr ( to_mmbr_id NUMBER ) IS
2374: SELECT memb.program_id
2375: FROM pv_pg_memberships memb
2376: ,pv_partner_program_b pvpp
2377: WHERE GLOBAL_MMBR_REQD_FLAG = 'Y'
2378: AND pvpp.program_id=memb.program_id
2379: AND memb.membership_id=to_mmbr_id;
2380:

Line 3413: FROM pv_partner_program_b

3409: , 'MONTH', add_months( start_date, membership_valid_period )
3410: , 'YEAR', add_months( start_date, 12*membership_valid_period )
3411: , null
3412: ) membership_end_date
3413: FROM pv_partner_program_b
3414: WHERE program_id=p_prgm_id;
3415:
3416: l_program_end_date DATE;
3417: l_membership_end_date DATE;