DBA Data[Home] [Help]

APPS.PAY_KR_PAYKRYTR_PKG dependencies on PAY_KR_FF_FUNCTIONS_PKG

Line 611: and pay_kr_ff_functions_pkg.is_exempted_dependent( pkc.contact_type,

607: and to_char(cei.effective_start_date(+), 'YYYY') = to_char(p_effective_date, 'YYYY')
608: and p_effective_date between nvl(ADDRESS_START_DATE, p_effective_date) and nvl(ADDRESS_END_DATE, p_effective_date)
609: and p_effective_date between nvl(pkc.date_start, p_effective_date)
610: and decode(pkc.cont_information9, 'D', trunc(add_months(nvl(pkc.date_end, p_effective_date),12),'YYYY')-1, nvl(pkc.date_end, p_effective_date) )
611: and pay_kr_ff_functions_pkg.is_exempted_dependent( pkc.contact_type,
612: pkc.cont_information11, -- Bug 7661820
613: pkc.national_identifier,
614: pkc.cont_information2,
615: pkc.cont_information3,