APPS.PAY_SIV_BUS dependencies on PAY_TEMPLATE_EXCLUSION_RULES

Line 884: -- a flexfield column in PAY_TEMPLATE_EXCLUSION_RULES.

880: ,p_object_version_number in number
881: ) is
882: --
883: -- Cursor to ensure that the default value column is not being used as
884: -- a flexfield column in PAY_TEMPLATE_EXCLUSION_RULES.
885: --
886: cursor csr_default_value_clash is
887: select null
888: from pay_template_exclusion_rules ter

Line 888: from pay_template_exclusion_rules ter

884: -- a flexfield column in PAY_TEMPLATE_EXCLUSION_RULES.
885: --
886: cursor csr_default_value_clash is
887: select null
888: from pay_template_exclusion_rules ter
889: where ter.template_id = p_template_id
890: and upper(ter.flexfield_column) = upper(p_default_value_column);
891: --
892: -- Cursor to make sure that the default value column is being used

Line 955: -- flexfield column on PAY_TEMPLATE_EXCLUSION_RULES.

951: fnd_message.raise_error;
952: end;
953: --
954: -- Check that the default value column does not clash with a
955: -- flexfield column on PAY_TEMPLATE_EXCLUSION_RULES.
956: --
957: open csr_default_value_clash;
958: fetch csr_default_value_clash into l_clash;
959: if csr_default_value_clash%found then

Line 997: from pay_template_exclusion_rules ter

993: -- Cursor to check that the exclusion_rule_id is valid.
994: --
995: cursor csr_exclusion_rule_id_valid is
996: select null
997: from pay_template_exclusion_rules ter
998: where ter.exclusion_rule_id = p_exclusion_rule_id
999: and ter.template_id = p_template_id;
1000: --
1001: l_proc varchar2(72) := g_package||'chk_exclusion_rule_id';