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

Line 1474: FROM pv_partner_program_b

1470: AND ben.delete_flag = 'N'
1471: AND ben.program_id in
1472: (
1473: SELECT program_id
1474: FROM pv_partner_program_b
1475: START WITH program_id in
1476: (
1477: SELECT /*+ leading(T) USE_NL(T MEM)*/ mem.program_id
1478: FROM pv_pg_memberships mem, (SELECT column_value FROM TABLE (CAST(p_partner_id AS JTF_NUMBER_TABLE))) t

Line 1613: FROM pv_partner_program_b

1609: SELECT ben.benefit_id, ben.program_benefits_id
1610: FROM pv_program_benefits ben
1611: WHERE ben.program_id IN (
1612: SELECT program_id
1613: FROM pv_partner_program_b
1614: START WITH program_id = p_program_id
1615: CONNECT BY PRIOR program_parent_id = program_id
1616: )
1617: AND ben.benefit_type_code = 'STORES'

Line 5248: FROM pv_partner_program_b

5244: SELECT partner_id, program_id
5245: FROM pv_pg_memberships
5246: WHERE program_id in (
5247: SELECT program_id
5248: FROM pv_partner_program_b
5249: WHERE program_level_code = 'MEMBERSHIP'
5250: START WITH program_id = p_program_id
5251: CONNECT BY PRIOR program_id = program_parent_id
5252: )