APPS.PAY_KR_YEA_DON_EFILE_PKG dependencies on PAY_KR_FF_FUNCTIONS_PKG

Line 163: 'NATIONALITY=P', decode(pay_kr_ff_functions_pkg.ni_nationality(pp.national_identifier),

159:
160: cursor csr_c(p_asg_id varchar2 default pay_magtape_generic.get_parameter_value('ASSIGN_ID'),p_effective_date date default fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))) is
161: select
162: 'NATIONAL_IDENTIFIER=P', pp.national_identifier,
163: 'NATIONALITY=P', decode(pay_kr_ff_functions_pkg.ni_nationality(pp.national_identifier),
164: 'K', '1',
165: '9'
166: ),
167: 'FULL_NAME=P', pp.last_name || pp.first_name,

Line 197: 'DONATOR_NATIONALITY=P', decode(pay_kr_ff_functions_pkg.ni_nationality(pae.aei_information13),

193: select 'DONATION_CODE=P', pae.aei_information5,
194: 'RECIPIENT_REG_NUM=P', pae.aei_information7,
195: 'RECIPIENT_NAME=P', pae.aei_information8,
196: 'RELATIONSHIP=P', pae.aei_information12,
197: 'DONATOR_NATIONALITY=P', decode(pay_kr_ff_functions_pkg.ni_nationality(pae.aei_information13),
198: 'K', '1','9'),
199: 'DONATOR_NAME=P', pp.last_name || pp.first_name,
200: 'DONATOR_REG_NUM=P', pae.aei_information13,
201: 'NUM_OF_DONATIONS=P', sum(nvl(pae.aei_information4, 1)),