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_BG_PARTNER_MATCHING_PUB dependencies on AMS_SOURCE_CODES

Line 906: FROM ams_source_codes ac, ams_act_partners acp, pv_partner_profiles pp

902: WHERE salesforce_id = c_salesforce_id;
903:
904: cursor lc_partners (pc_source_promotion_id number) is
905: SELECT distinct acp.partner_id, rownum
906: FROM ams_source_codes ac, ams_act_partners acp, pv_partner_profiles pp
907: WHERE ac.source_code_id = pc_source_promotion_id
908: AND ac.arc_source_code_for in ('CAMP', 'CSCH') AND ac.source_code_for_id = acp.act_partner_used_by_id
909: AND acp.arc_act_partner_used_by = ac.arc_source_code_for AND acp.partner_id = pp.partner_id;
910: