[Home] [Help]
23: 'NATIONAL_IDENTIFIER=P', pp.national_identifier,
24: 'FULL_NAME=P', pp.last_name || pp.first_name, -- Bug 7800013
25: 'CORP_NAME=P', choi.org_information1,
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')
99: ------------------------------------------------------------------------
100:
101: cursor csr_b is
102: select
103: 'MED_REG_NO=P', pay_kr_yea_med_efile_conc_pkg.get_medical_reg_no(
104: assignment_id,
105: to_date(to_char(g_target_year),'yyyy'),
106: med_reg_no),
107: 'MED_NAME=P', med_name ,
109: 'TOTAL_MED_NO_OF_PAYMENTS=P', total_med_no_of_payments ,
110: 'TOTAL_EXPENSE_AMOUNT=P', total_expense_amount ,
111: 'RELATIONSHIP=P', relarionship ,
112: 'SOURCE_CODE=P' , source_code,
113: 'RESIDENT_REG_NO=P', pay_kr_yea_med_efile_conc_pkg.get_resident_reg_no(
114: assignment_id,
115: to_date(to_char(g_target_year),'yyyy'),
116: resident_reg_no),
117: 'DISABLED_OR_AGED=P', disabled_or_aged,