DBA Data[Home] [Help]

APPS.PAY_KR_PAYKRYTR_PKG dependencies on PAY_KR_FF_FUNCTIONS_PKG

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

240: and to_char(cei.effective_start_date(+), 'YYYY') = to_char(p_effective_date, 'YYYY')
241: and p_effective_date between nvl(ADDRESS_START_DATE, p_effective_date) and nvl(ADDRESS_END_DATE, p_effective_date)
242: and p_effective_date between nvl(pkc.date_start, p_effective_date)
243: 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) )
244: and pay_kr_ff_functions_pkg.is_exempted_dependent( pkc.contact_type,
245: pkc.national_identifier,
246: pkc.cont_information2,
247: pkc.cont_information3,
248: pkc.cont_information4,