DBA Data[Home] [Help]

APPS.PAY_TCO_BUS dependencies on PAY_FORMULA_RESULT_RULES_F

Line 607: from pay_formula_result_rules_f frr

603: bf.effective_start_date and bf.effective_end_date;
604: --
605: cursor csr_sfr_exists is
606: select null
607: from pay_formula_result_rules_f frr
608: where frr.formula_result_rule_id = p_core_object_id
609: and frr.business_group_id = p_business_group_id
610: and p_effective_date between
611: frr.effective_start_date and frr.effective_end_date;

Line 774: l_table := 'PAY_FORMULA_RESULT_RULES_F';

770: raise l_error;
771: end if;
772: close csr_spr_exists;
773: elsif p_core_object_type = pay_tco_shd.g_sfr_lookup_type then
774: l_table := 'PAY_FORMULA_RESULT_RULES_F';
775: open csr_sfr_exists;
776: fetch csr_sfr_exists into l_exists;
777: if csr_sfr_exists%notfound then
778: close csr_sfr_exists;