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.AD_PA_EDIT_ADVISOR_CRITERIA dependencies on AD_PA_CRITERIA_PRODUCTS

Line 16: from ad_pa_criteria_products

12: l_lub number;
13: cursor ad_pa_cri_prod is
14: select product_abbreviation,product_family_abbreviation,
15: require_family_pack,require_mini_pack,require_high_priority
16: from ad_pa_criteria_products
17: where advisor_criteria_id =p_advisor_criteria_id
18: and product_abbreviation = p_product_abbreviation;
19: BEGIN
20: l_last_update_date := sysdate;

Line 27: update AD_PA_CRITERIA_products

23: if PRODUCT_REC.require_family_pack <> p_require_family_pack or
24: PRODUCT_REC.require_mini_pack <> p_require_family_pack or
25: PRODUCT_REC.require_high_priority <> p_require_high_priority then
26:
27: update AD_PA_CRITERIA_products
28: set
29: require_family_pack =p_require_family_pack,
30: require_mini_pack =p_require_mini_pack,
31: REQUIRE_HIGH_PRIORITY=p_require_high_priority,