DBA Data[Home] [Help]

APPS.PAY_KR_YEA_MED_EFILE_PKG dependencies on PAY_KR_FF_FUNCTIONS_PKG

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

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

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

111: assignment_id,
112: to_date(to_char(g_target_year),'yyyy'),
113: resident_reg_no),
114: 'DISABLED_OR_AGED=P', disabled_or_aged,
115: 'DEPNT_NATIONALITY=P', decode(pay_kr_ff_functions_pkg.ni_nationality(resident_reg_no),'F','9','1')
116: from
117: (
118: select
119: pae.assignment_id assignment_id ,