DBA Data[Home] [Help]

APPS.PAY_IN_EXC dependencies on PAY_IN_PROF_TAX_PKG

Line 790: AND pay_in_prof_tax_pkg.get_state(hsc.segment3) = target.org_information1

786: AND p_effective_date BETWEEN ASSIGN.effective_start_date AND ASSIGN.effective_end_date
787: AND assign.business_group_id = target.organization_id
788: AND target.org_information_context = 'PER_IN_PT_FREQUENCY'
789: AND assign.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
790: AND pay_in_prof_tax_pkg.get_state(hsc.segment3) = target.org_information1
791: AND p_effective_date BETWEEN fnd_date.canonical_to_date(target.org_information3)
792: AND fnd_date.canonical_to_date(nvl(target.org_information4,'4712/12/31 00:00:00'));
793:
794: BEGIN