eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_KR_YEA_MAGTAPE_PKG dependencies on PAY_KR_FF_FUNCTIONS_PKG

Line 202: 'NATIONALITY=P', decode(pay_kr_ff_functions_pkg.ni_nationality(asg.assignment_id,p_effective_date),'K','1','9') nationality,

198: pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))
199: ) is
200: -- Bug 5654127
201: select 'CONTACT_TYPE=P', '0' contact_type,
202: 'NATIONALITY=P', decode(pay_kr_ff_functions_pkg.ni_nationality(asg.assignment_id,p_effective_date),'K','1','9') nationality,
203: 'BASIC_FLAG=P', '1' basic_exem_flag,
204: 'DISABLE_FLAG=P', decode(pay_kr_ff_functions_pkg.disabled_flag(per.person_id,p_effective_date),'Y','1',' ') disabled_exem_flag,
205: 'RAISING_CHILD=P', ' ' child_raising_exem,
206: 'INS_PREM_NTS=P', '0' ins_prem_nts,

Line 204: 'DISABLE_FLAG=P', decode(pay_kr_ff_functions_pkg.disabled_flag(per.person_id,p_effective_date),'Y','1',' ') disabled_exem_flag,

200: -- Bug 5654127
201: select 'CONTACT_TYPE=P', '0' contact_type,
202: 'NATIONALITY=P', decode(pay_kr_ff_functions_pkg.ni_nationality(asg.assignment_id,p_effective_date),'K','1','9') nationality,
203: 'BASIC_FLAG=P', '1' basic_exem_flag,
204: 'DISABLE_FLAG=P', decode(pay_kr_ff_functions_pkg.disabled_flag(per.person_id,p_effective_date),'Y','1',' ') disabled_exem_flag,
205: 'RAISING_CHILD=P', ' ' child_raising_exem,
206: 'INS_PREM_NTS=P', '0' ins_prem_nts,
207: 'INS_PREM_OTH=P', '0' ins_prem_oth,
208: 'MED_EXP_NTS=P', '0' med_exp_nts,

Line 218: 'SNR_FLAG=P', pay_kr_ff_functions_pkg.aged_flag(per.national_identifier,to_date('31-12-'||to_char(p_effective_date,'rrrr'),'dd-mm-rrrr')) snr_flag,

214: 'CASH_EXP_NTS=P', '0' cash_exp_nts,
215: 'CONT_NAME=P', 'Y' full_name,
216: 'CONT_NI=P', per.national_identifier national_identifier,
217: /* Bug 6622876 */
218: 'SNR_FLAG=P', pay_kr_ff_functions_pkg.aged_flag(per.national_identifier,to_date('31-12-'||to_char(p_effective_date,'rrrr'),'dd-mm-rrrr')) snr_flag,
219: 'SUPER_AGED_FLAG=P', pay_kr_ff_functions_pkg.super_aged_flag(per.national_identifier,to_date('31-12-'||to_char(p_effective_date,'rrrr'),'dd-mm-rrrr')) super_aged_flag,
220: /* Bug 6784288 */
221: 'ADDTL_CHILD_FLAG=P', '0' addtl_child_flag,
222: /* End of Bug 6622876 */

Line 219: 'SUPER_AGED_FLAG=P', pay_kr_ff_functions_pkg.super_aged_flag(per.national_identifier,to_date('31-12-'||to_char(p_effective_date,'rrrr'),'dd-mm-rrrr')) super_aged_flag,

215: 'CONT_NAME=P', 'Y' full_name,
216: 'CONT_NI=P', per.national_identifier national_identifier,
217: /* Bug 6622876 */
218: 'SNR_FLAG=P', pay_kr_ff_functions_pkg.aged_flag(per.national_identifier,to_date('31-12-'||to_char(p_effective_date,'rrrr'),'dd-mm-rrrr')) snr_flag,
219: 'SUPER_AGED_FLAG=P', pay_kr_ff_functions_pkg.super_aged_flag(per.national_identifier,to_date('31-12-'||to_char(p_effective_date,'rrrr'),'dd-mm-rrrr')) super_aged_flag,
220: /* Bug 6784288 */
221: 'ADDTL_CHILD_FLAG=P', '0' addtl_child_flag,
222: /* End of Bug 6622876 */
223: '1' l_dummy

Line 233: 'BASIC_FLAG=P', decode(pkc.cont_information2,'Y',decode(pay_kr_ff_functions_pkg.dpnt_eligible_for_basic_exem(

229: and p_effective_date between asg.effective_start_date and asg.effective_end_date
230: union
231: select 'CONTACT_TYPE=P', pkc.rel_code contact_type,
232: 'NATIONALITY=P', pkc.cont_nationality nationality,
233: 'BASIC_FLAG=P', decode(pkc.cont_information2,'Y',decode(pay_kr_ff_functions_pkg.dpnt_eligible_for_basic_exem(
234: pkc.contact_type,pkc.national_identifier, pkc.cont_information2, pkc.cont_information4,
235: pkc.cont_information8, p_effective_date),'Y','1',' '),' ') basic_exem_flag,
236: 'DISABLE_FLAG=P', decode(pkc.cont_information4,'Y','1',' ') disabled_exem_flag,
237: 'RAISING_CHILD=P', decode(pkc.cont_information7 ,'Y',decode(pay_kr_ff_functions_pkg.child_flag(

Line 237: 'RAISING_CHILD=P', decode(pkc.cont_information7 ,'Y',decode(pay_kr_ff_functions_pkg.child_flag(

233: 'BASIC_FLAG=P', decode(pkc.cont_information2,'Y',decode(pay_kr_ff_functions_pkg.dpnt_eligible_for_basic_exem(
234: pkc.contact_type,pkc.national_identifier, pkc.cont_information2, pkc.cont_information4,
235: pkc.cont_information8, p_effective_date),'Y','1',' '),' ') basic_exem_flag,
236: 'DISABLE_FLAG=P', decode(pkc.cont_information4,'Y','1',' ') disabled_exem_flag,
237: 'RAISING_CHILD=P', decode(pkc.cont_information7 ,'Y',decode(pay_kr_ff_functions_pkg.child_flag(
238: pkc.national_identifier,p_effective_date), 'Y', '1', ' '), ' ') child_raising_exem,
239: 'INS_PREM_NTS=P', to_char(nvl(cei.cei_information1, '0')+ nvl(cei.cei_information10, '0')) ins_prem_nts,
240: 'INS_PREM_OTH=P', to_char(nvl(cei.cei_information2, '0')+ nvl(cei.cei_information11, '0')) ins_prem_oth,
241: 'MED_EXP_NTS=P', nvl(cei.cei_information3, '0') med_exp_nts,

Line 251: 'SNR_FLAG=P', decode(pkc.cont_information3,'Y',pay_kr_ff_functions_pkg.aged_flag(pkc.national_identifier,to_date('31-12-'||to_char(p_effective_date,'rrrr'),'dd-mm-rrrr'))) snr_flag,

247: 'CASH_EXP_NTS=P', nvl(cei.cei_information9, '0') cash_exp_nts,
248: 'CONT_NAME=P', pkc.full_name full_name,
249: 'CONT_NI=P', pkc.national_identifier national_identifier,
250: /* Bug 6622876 */
251: 'SNR_FLAG=P', decode(pkc.cont_information3,'Y',pay_kr_ff_functions_pkg.aged_flag(pkc.national_identifier,to_date('31-12-'||to_char(p_effective_date,'rrrr'),'dd-mm-rrrr'))) snr_flag,
252: 'SUPER_AGED_FLAG=P', decode(pkc.cont_information3,'Y',pay_kr_ff_functions_pkg.super_aged_flag(pkc.national_identifier,to_date('31-12-'||to_char(p_effective_date,'rrrr'),'dd-mm-rrrr'))) super_aged_flag,
253: /* Bug 6784288 Bug 6825145 */
254: 'ADDTL_CHILD_FLAG=P', decode(pkc.cont_information2,'Y',decode(decode(pkc.cont_information11,'4',pay_kr_ff_functions_pkg.underaged_dpnt_flag(pkc.contact_type,pkc.national_identifier,p_effective_date),
255: pay_kr_ff_functions_pkg.addtl_child_flag(pkc.contact_type,pkc.national_identifier,p_effective_date)),'Y','1','0'),'0') addtl_child_flag,

Line 252: 'SUPER_AGED_FLAG=P', decode(pkc.cont_information3,'Y',pay_kr_ff_functions_pkg.super_aged_flag(pkc.national_identifier,to_date('31-12-'||to_char(p_effective_date,'rrrr'),'dd-mm-rrrr'))) super_aged_flag,

248: 'CONT_NAME=P', pkc.full_name full_name,
249: 'CONT_NI=P', pkc.national_identifier national_identifier,
250: /* Bug 6622876 */
251: 'SNR_FLAG=P', decode(pkc.cont_information3,'Y',pay_kr_ff_functions_pkg.aged_flag(pkc.national_identifier,to_date('31-12-'||to_char(p_effective_date,'rrrr'),'dd-mm-rrrr'))) snr_flag,
252: 'SUPER_AGED_FLAG=P', decode(pkc.cont_information3,'Y',pay_kr_ff_functions_pkg.super_aged_flag(pkc.national_identifier,to_date('31-12-'||to_char(p_effective_date,'rrrr'),'dd-mm-rrrr'))) super_aged_flag,
253: /* Bug 6784288 Bug 6825145 */
254: 'ADDTL_CHILD_FLAG=P', decode(pkc.cont_information2,'Y',decode(decode(pkc.cont_information11,'4',pay_kr_ff_functions_pkg.underaged_dpnt_flag(pkc.contact_type,pkc.national_identifier,p_effective_date),
255: pay_kr_ff_functions_pkg.addtl_child_flag(pkc.contact_type,pkc.national_identifier,p_effective_date)),'Y','1','0'),'0') addtl_child_flag,
256: /* End of Bug 6622876 */

Line 254: 'ADDTL_CHILD_FLAG=P', decode(pkc.cont_information2,'Y',decode(decode(pkc.cont_information11,'4',pay_kr_ff_functions_pkg.underaged_dpnt_flag(pkc.contact_type,pkc.national_identifier,p_effective_date),

250: /* Bug 6622876 */
251: 'SNR_FLAG=P', decode(pkc.cont_information3,'Y',pay_kr_ff_functions_pkg.aged_flag(pkc.national_identifier,to_date('31-12-'||to_char(p_effective_date,'rrrr'),'dd-mm-rrrr'))) snr_flag,
252: 'SUPER_AGED_FLAG=P', decode(pkc.cont_information3,'Y',pay_kr_ff_functions_pkg.super_aged_flag(pkc.national_identifier,to_date('31-12-'||to_char(p_effective_date,'rrrr'),'dd-mm-rrrr'))) super_aged_flag,
253: /* Bug 6784288 Bug 6825145 */
254: 'ADDTL_CHILD_FLAG=P', decode(pkc.cont_information2,'Y',decode(decode(pkc.cont_information11,'4',pay_kr_ff_functions_pkg.underaged_dpnt_flag(pkc.contact_type,pkc.national_identifier,p_effective_date),
255: pay_kr_ff_functions_pkg.addtl_child_flag(pkc.contact_type,pkc.national_identifier,p_effective_date)),'Y','1','0'),'0') addtl_child_flag,
256: /* End of Bug 6622876 */
257: '2' l_dummy
258: from pay_kr_cont_details_v pkc,

Line 255: pay_kr_ff_functions_pkg.addtl_child_flag(pkc.contact_type,pkc.national_identifier,p_effective_date)),'Y','1','0'),'0') addtl_child_flag,

251: 'SNR_FLAG=P', decode(pkc.cont_information3,'Y',pay_kr_ff_functions_pkg.aged_flag(pkc.national_identifier,to_date('31-12-'||to_char(p_effective_date,'rrrr'),'dd-mm-rrrr'))) snr_flag,
252: 'SUPER_AGED_FLAG=P', decode(pkc.cont_information3,'Y',pay_kr_ff_functions_pkg.super_aged_flag(pkc.national_identifier,to_date('31-12-'||to_char(p_effective_date,'rrrr'),'dd-mm-rrrr'))) super_aged_flag,
253: /* Bug 6784288 Bug 6825145 */
254: 'ADDTL_CHILD_FLAG=P', decode(pkc.cont_information2,'Y',decode(decode(pkc.cont_information11,'4',pay_kr_ff_functions_pkg.underaged_dpnt_flag(pkc.contact_type,pkc.national_identifier,p_effective_date),
255: pay_kr_ff_functions_pkg.addtl_child_flag(pkc.contact_type,pkc.national_identifier,p_effective_date)),'Y','1','0'),'0') addtl_child_flag,
256: /* End of Bug 6622876 */
257: '2' l_dummy
258: from pay_kr_cont_details_v pkc,
259: per_contact_extra_info_f cei -- Bug 5872042

Line 262: and pay_kr_ff_functions_pkg.is_exempted_dependent(pkc.contact_type, pkc.national_identifier, pkc.cont_information2,

258: from pay_kr_cont_details_v pkc,
259: per_contact_extra_info_f cei -- Bug 5872042
260: where pkc.assignment_id = p_assignment_id
261: and p_effective_date between pkc.emp_start_date and pkc.emp_end_date
262: and pay_kr_ff_functions_pkg.is_exempted_dependent(pkc.contact_type, pkc.national_identifier, pkc.cont_information2,
263: pkc.cont_information3,
264: pkc.cont_information4,
265: pkc.cont_information7,
266: pkc.cont_information8,