APPS.PAY_KR_PAYKRYRS_PKG dependencies on PAY_KR_FF_FUNCTIONS_PKG

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

245: and p_effective_date between cont_start_date and cont_end_date
246: and p_effective_date between nvl(ADDRESS_START_DATE,p_effective_date) and nvl(ADDRESS_END_DATE, p_effective_date)
247: and p_effective_date between nvl(pkc.date_start, p_effective_date)
248: 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) )
249: and pay_kr_ff_functions_pkg.is_exempted_dependent( pkc.contact_type,
250: pkc.cont_information11, -- Bug 7661820
251: pkc.national_identifier,
252: pkc.cont_information2,
253: pkc.cont_information3,

Line 1299: if (pay_kr_ff_functions_pkg.ni_nationality(p_assignment_id, to_date('3112'||to_char(p_year), 'DDMMYYYY')) = 'F' or l_foreign_residency_flag = 'Y') then

1295: exception
1296: when no_data_found then
1297: l_foreign_residency_flag := 'N';
1298: end;
1299: if (pay_kr_ff_functions_pkg.ni_nationality(p_assignment_id, to_date('3112'||to_char(p_year), 'DDMMYYYY')) = 'F' or l_foreign_residency_flag = 'Y') then
1300: p_nationality_type := 'F';
1301: else
1302: p_nationality_type := 'K';
1303: end if;