DBA Data[Home] [Help]

APPS.PAY_KR_PAYKRYRS_PKG dependencies on PAY_KR_FF_FUNCTIONS_PKG

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

167: and p_effective_date between cont_start_date and cont_end_date
168: and p_effective_date between nvl(ADDRESS_START_DATE,p_effective_date) and nvl(ADDRESS_END_DATE, p_effective_date)
169: and p_effective_date between nvl(pkc.date_start, p_effective_date)
170: 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) )
171: and pay_kr_ff_functions_pkg.is_exempted_dependent( pkc.contact_type,
172: pkc.national_identifier,
173: pkc.cont_information2,
174: pkc.cont_information3,
175: pkc.cont_information4,