DBA Data[Home] [Help]

APPS.PAY_TCO_BUS dependencies on PAY_SUB_CLASSIFICATION_RULES_F

Line 577: from pay_sub_classification_rules_f scr

573: et.effective_start_date and et.effective_end_date;
574: --
575: cursor csr_ssr_exists is
576: select null
577: from pay_sub_classification_rules_f scr
578: where scr.sub_classification_rule_id = p_core_object_id
579: and scr.business_group_id = p_business_group_id
580: and p_effective_date between
581: scr.effective_start_date and scr.effective_end_date;

Line 729: l_table := 'PAY_SUB_CLASSIFICATION_RULES_F';

725: raise l_error;
726: end if;
727: close csr_set_exists;
728: elsif p_core_object_type = pay_tco_shd.g_ssr_lookup_type then
729: l_table := 'PAY_SUB_CLASSIFICATION_RULES_F';
730: open csr_ssr_exists;
731: fetch csr_ssr_exists into l_exists;
732: if csr_ssr_exists%notfound then
733: close csr_ssr_exists;