APPS.PAY_TCO_BUS dependencies on PAY_ITERATIVE_RULES_F

Line 623: from pay_iterative_rules_f pir

619: spr.effective_start_date and spr.effective_end_date;
620: --
621: cursor csr_sir_exists is
622: select null
623: from pay_iterative_rules_f pir
624: where pir.iterative_rule_id = p_core_object_id
625: and pir.business_group_id = p_business_group_id
626: and p_effective_date between
627: pir.effective_start_date and pir.effective_end_date;

Line 783: l_table := 'PAY_ITERATIVE_RULES_F';

779: raise l_error;
780: end if;
781: close csr_sfr_exists;
782: elsif p_core_object_type = pay_tco_shd.g_sir_lookup_type then
783: l_table := 'PAY_ITERATIVE_RULES_F';
784: open csr_sir_exists;
785: fetch csr_sir_exists into l_exists;
786: if csr_sir_exists%notfound then
787: close csr_sir_exists;