DBA Data[Home] [Help]

APPS.PAY_KR_YEA_MED_EFILE_PKG dependencies on PAY_KR_FF_FUNCTIONS_PKG

Line 30: 'EMP_NATIONALITY=P', decode(pay_kr_ff_functions_pkg.ni_nationality(pp.national_identifier),'F','9'

26: 'ASSIGN_ID=P', paa.assignment_id,
27: 'VALIDATION=P', pay_kr_yea_med_efile_conc_pkg.validate_det_medical_rec(
28: paa.assignment_id,
29: to_date(to_char(g_target_year),'yyyy') ),
30: 'EMP_NATIONALITY=P', decode(pay_kr_ff_functions_pkg.ni_nationality(pp.national_identifier),'F','9'
31: ,'1')
32: from
33: per_people_f pp,
34: per_periods_of_service pds,

Line 118: 'DEPNT_NATIONALITY=P', decode(pay_kr_ff_functions_pkg.ni_nationality(resident_reg_no),'F','9','1'),

114: assignment_id,
115: to_date(to_char(g_target_year),'yyyy'),
116: resident_reg_no),
117: 'DISABLED_OR_AGED=P', disabled_or_aged,
118: 'DEPNT_NATIONALITY=P', decode(pay_kr_ff_functions_pkg.ni_nationality(resident_reg_no),'F','9','1'),
119: 'REP_PERIOD_CODE=P', g_rep_period_code -- Bug 9251566
120: from
121: (
122: select