DBA Data[Home] [Help]

APPS.PAY_KR_YEA_MAGTAPE_PKG dependencies on HR_GENERAL

Line 375: 'FIN_INST_NAME=P', hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',aei_information3),

371: select
372: 'INFORMATION_TYPE=P', information_type,
373: 'EXEMPTION_TYPE=P', decode(aei_information2,'1','11','2','12') exemption_type,
374: 'FIN_INST_CODE=P', aei_information3,
375: 'FIN_INST_NAME=P', hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',aei_information3),
376: 'ACCOUNT_NUMBER=P', aei_information4,
377: 'YEAR=P', '00' year,
378: 'CONT_AMOUNT=P', aei_information5,
379: 'F_RECORD_COUNT=P', pay_kr_yea_magtape_fun_pkg.f_record_count(p_assignment_id,p_effective_date,p_assignment_action_id),

Line 396: 'FIN_INST_NAME=P', hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',aei_information3),

392: select
393: 'INFORMATION_TYPE=P', information_type,
394: 'EXEMPTION_TYPE=P', decode(aei_information2,'1','21','2','22') exemption_type,
395: 'FIN_INST_CODE=P', aei_information3,
396: 'FIN_INST_NAME=P', hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',aei_information3),
397: 'ACCOUNT_NUMBER=P', aei_information4,
398: 'YEAR=P', '00' year,
399: 'CONT_AMOUNT=P', aei_information5,
400: 'F_RECORD_COUNT=P', pay_kr_yea_magtape_fun_pkg.f_record_count(p_assignment_id,p_effective_date,p_assignment_action_id),

Line 418: 'FIN_INST_NAME=P', hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',aei_information3),

414: select
415: 'INFORMATION_TYPE=P', information_type,
416: 'EXEMPTION_TYPE=P', decode(aei_information2,'HST1','31','HST5','32','HST4','33','HST3','34') exemption_type,
417: 'FIN_INST_CODE=P', aei_information3,
418: 'FIN_INST_NAME=P', hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',aei_information3),
419: 'ACCOUNT_NUMBER=P', aei_information4,
420: 'YEAR=P', '00' year,
421: 'CONT_AMOUNT=P', aei_information5,
422: 'F_RECORD_COUNT=P', pay_kr_yea_magtape_fun_pkg.f_record_count(p_assignment_id,p_effective_date,p_assignment_action_id),

Line 440: 'FIN_INST_NAME=P', hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',aei_information3),

436: select
437: 'INFORMATION_TYPE=P', information_type,
438: 'EXEMPTION_TYPE=P', '41' exemption_type,
439: 'FIN_INST_CODE=P', aei_information3,
440: 'FIN_INST_NAME=P', hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',aei_information3),
441: 'ACCOUNT_NUMBER=P', aei_information4,
442: 'YEAR=P', decode(aei_information2,'1','01','2','02','3','03') year,
443: 'CONT_AMOUNT=P', aei_information5,
444: 'F_RECORD_COUNT=P', pay_kr_yea_magtape_fun_pkg.f_record_count(p_assignment_id,p_effective_date,p_assignment_action_id),