DBA Data[Home] [Help]

APPS.PV_PROCESS_RULE_PVT dependencies on FND_PROFILE_OPTIONS

Line 628: fnd_profile_options c

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
632: a.application_Id = 691 and

Line 1749: FROM fnd_profile_options a,

1745: l_result VARCHAR2(1);
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