APPS.PV_PROCESS_RULE_PVT dependencies on FND_PROFILE_OPTION_VALUES

Line 623: -- SQL is tuned to make use of an index on fnd_profile_option_values

619: where process_rule_id = pc_rule_id;
620: */
621:
622: -- ------------------------------------------------------------------------
623: -- SQL is tuned to make use of an index on fnd_profile_option_values
624: -- ------------------------------------------------------------------------
625: cursor lc_validate_rule_profile_ref(pc_rule_id number) is
626: select process_rule_name
627: from fnd_profile_option_values a, pv_process_rules_tl b,

Line 627: from fnd_profile_option_values a, pv_process_rules_tl b,

623: -- SQL is tuned to make use of an index on fnd_profile_option_values
624: -- ------------------------------------------------------------------------
625: cursor lc_validate_rule_profile_ref(pc_rule_id number) is
626: select process_rule_name
627: from fnd_profile_option_values a, pv_process_rules_tl b,
628: fnd_profile_options c
629: where a.profile_option_value = to_char(pc_rule_id)
630: and a.profile_option_value = b.process_rule_id AND
631: b.language = USERENV('LANG') and

Line 1750: fnd_profile_option_values b

1746:
1747: CURSOR lc_check_rule_reference IS
1748: SELECT 'x' result
1749: FROM fnd_profile_options a,
1750: fnd_profile_option_values b
1751: WHERE a.profile_option_id = b.profile_option_id AND
1752: a.profile_option_name = 'PV_AUTO_MATCHING_RULE' AND
1753: b.application_id = 691 AND
1754: b.profile_option_value = TO_CHAR(p_parent_rule_id);