DBA Data[Home] [Help]

APPS.PAY_KR_YEA_MED_EFILE_PKG dependencies on PAY_KR_YEA_MED_EFILE_CONC_PKG

Line 24: 'VALIDATION=P', pay_kr_yea_med_efile_conc_pkg.validate_det_medical_rec(

20: 'NATIONAL_IDENTIFIER=P', pp.national_identifier,
21: 'FULL_NAME=P', pp.full_name,
22: 'CORP_NAME=P', choi.org_information1,
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')

Line 100: 'MED_REG_NO=P', pay_kr_yea_med_efile_conc_pkg.get_medical_reg_no(

96: ------------------------------------------------------------------------
97:
98: cursor csr_b is
99: select
100: 'MED_REG_NO=P', pay_kr_yea_med_efile_conc_pkg.get_medical_reg_no(
101: assignment_id,
102: to_date(to_char(g_target_year),'yyyy'),
103: med_reg_no),
104: 'MED_NAME=P', med_name ,

Line 110: 'RESIDENT_REG_NO=P', pay_kr_yea_med_efile_conc_pkg.get_resident_reg_no(

106: 'CARD_EXPENSE_AMOUNT=P', card_expense_amount ,
107: 'CASH_MED_NO_OF_PAYMENTS=P', cash_med_no_of_payments ,
108: 'CASH_EXPENSE_AMOUNT=P', cash_expense_amount ,
109: 'RELATIONSHIP=P', relarionship ,
110: 'RESIDENT_REG_NO=P', pay_kr_yea_med_efile_conc_pkg.get_resident_reg_no(
111: assignment_id,
112: to_date(to_char(g_target_year),'yyyy'),
113: resident_reg_no),
114: 'DISABLED_OR_AGED=P', disabled_or_aged,