[Home] [Help]
685: pay_in_utils.set_location(g_debug,'Using 24Q Data',3);
686: OPEN c_24q_ee_sum(p_challan_number,g_24q_payroll_act_id);
687: FETCH c_24q_ee_sum INTO l_last_sum;
688: CLOSE c_24q_ee_sum;
689: l_last_sum := pay_in_24q_er_returns.get_format_value(l_last_sum);
690: END IF;
691:
692: pay_in_utils.set_location(g_debug,'Leaving: '|| g_package||'.update_challans',1);
693: RETURN l_last_sum;
5299: ,p_action_information3 => g_gre_id
5300: ,p_action_information4 => tab_liv_pe_data.pan_number
5301: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
5302: ,p_action_information6 => tab_liv_pe_data.full_name
5303: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
5304: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
5305: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
5306: ,p_action_information10 => 'D'
5307: ,p_action_information11 => 'C4'
5404: ,p_action_information3 => g_gre_id
5405: ,p_action_information4 => tab_liv_pe_data.pan_number
5406: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
5407: ,p_action_information6 => tab_liv_pe_data.full_name
5408: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
5409: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
5410: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
5411: ,p_action_information10 => 'A'
5412: ,p_action_information11 => 'C4'
5478: ,p_action_information3 => g_gre_id
5479: ,p_action_information4 => tab_liv_pe_data.pan_number
5480: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
5481: ,p_action_information6 => tab_liv_pe_data.full_name
5482: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
5483: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
5484: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
5485: ,p_action_information10 => 'NA'
5486: ,p_action_information11 => 'C5'
5682: ,p_action_information3 => g_gre_id
5683: ,p_action_information4 => tab_liv_pe_data.pan_number
5684: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
5685: ,p_action_information6 => tab_liv_pe_data.full_name
5686: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
5687: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
5688: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
5689: ,p_action_information10 => 'NA'
5690: ,p_action_information11 => 'C5'
5744: ,p_action_information3 => g_gre_id
5745: ,p_action_information4 => tab_liv_pe_data.pan_number
5746: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
5747: ,p_action_information6 => tab_liv_pe_data.full_name
5748: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
5749: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
5750: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
5751: ,p_action_information10 => 'A'
5752: ,p_action_information11 => 'C4'
5851: ,p_action_information3 => g_gre_id
5852: ,p_action_information4 => tab_liv_pe_data.pan_number
5853: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
5854: ,p_action_information6 => tab_liv_pe_data.full_name
5855: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
5856: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
5857: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
5858: ,p_action_information10 => 'D'
5859: ,p_action_information11 => 'C4'
6056: ,p_action_information3 => g_gre_id
6057: ,p_action_information4 => tab_liv_pe_data.pan_number
6058: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
6059: ,p_action_information6 => tab_liv_pe_data.full_name
6060: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
6061: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
6062: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
6063: ,p_action_information10 => 'NA'
6064: ,p_action_information11 => 'C5'
6106: ,p_action_information3 => g_gre_id
6107: ,p_action_information4 => tab_liv_pe_data.pan_number
6108: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
6109: ,p_action_information6 => tab_liv_pe_data.full_name
6110: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
6111: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
6112: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
6113: ,p_action_information10 => 'D'
6114: ,p_action_information11 => 'C4'
6198: ,p_action_information3 => g_gre_id
6199: ,p_action_information4 => tab_liv_pe_data.pan_number
6200: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
6201: ,p_action_information6 => tab_liv_pe_data.full_name
6202: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
6203: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
6204: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
6205: ,p_action_information10 => 'A'
6206: ,p_action_information11 => 'C4'