APPS.PAY_TCO_BUS dependencies on PAY_STATUS_PROCESSING_RULES_F

Line 615: from pay_status_processing_rules_f spr

611: frr.effective_start_date and frr.effective_end_date;
612: --
613: cursor csr_spr_exists is
614: select null
615: from pay_status_processing_rules_f spr
616: where spr.status_processing_rule_id = p_core_object_id
617: and spr.business_group_id = p_business_group_id
618: and p_effective_date between
619: spr.effective_start_date and spr.effective_end_date;

Line 765: l_table := 'PAY_STATUS_PROCESSING_RULES_F';

761: raise l_error;
762: end if;
763: close csr_sbf_exists;
764: elsif p_core_object_type = pay_tco_shd.g_spr_lookup_type then
765: l_table := 'PAY_STATUS_PROCESSING_RULES_F';
766: open csr_spr_exists;
767: fetch csr_spr_exists into l_exists;
768: if csr_spr_exists%notfound then
769: close csr_spr_exists;