[Home] [Help]
750: pay_in_utils.set_location(g_debug,'Using 24Q Data',3);
751: OPEN c_24q_ee_sum(p_challan_number,g_24q_payroll_act_id);
752: FETCH c_24q_ee_sum INTO l_last_sum;
753: CLOSE c_24q_ee_sum;
754: l_last_sum := pay_in_24q_er_returns.get_format_value(l_last_sum);
755: END IF;
756:
757: pay_in_utils.set_location(g_debug,'Leaving: '|| g_package||'.update_challans',1);
758: RETURN l_last_sum;
5623: ,p_action_information3 => g_gre_id
5624: ,p_action_information4 => tab_liv_pe_data.pan_number
5625: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
5626: ,p_action_information6 => tab_liv_pe_data.full_name
5627: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
5628: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
5629: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
5630: ,p_action_information10 => 'D'
5631: ,p_action_information11 => 'C4'
5728: ,p_action_information3 => g_gre_id
5729: ,p_action_information4 => tab_liv_pe_data.pan_number
5730: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
5731: ,p_action_information6 => tab_liv_pe_data.full_name
5732: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
5733: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
5734: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
5735: ,p_action_information10 => 'A'
5736: ,p_action_information11 => 'C4'
5802: ,p_action_information3 => g_gre_id
5803: ,p_action_information4 => tab_liv_pe_data.pan_number
5804: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
5805: ,p_action_information6 => tab_liv_pe_data.full_name
5806: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
5807: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
5808: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
5809: ,p_action_information10 => 'NA'
5810: ,p_action_information11 => 'C5'
6006: ,p_action_information3 => g_gre_id
6007: ,p_action_information4 => tab_liv_pe_data.pan_number
6008: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
6009: ,p_action_information6 => tab_liv_pe_data.full_name
6010: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
6011: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
6012: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
6013: ,p_action_information10 => 'NA'
6014: ,p_action_information11 => 'C5'
6068: ,p_action_information3 => g_gre_id
6069: ,p_action_information4 => tab_liv_pe_data.pan_number
6070: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
6071: ,p_action_information6 => tab_liv_pe_data.full_name
6072: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
6073: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
6074: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
6075: ,p_action_information10 => 'A'
6076: ,p_action_information11 => 'C4'
6175: ,p_action_information3 => g_gre_id
6176: ,p_action_information4 => tab_liv_pe_data.pan_number
6177: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
6178: ,p_action_information6 => tab_liv_pe_data.full_name
6179: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
6180: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
6181: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
6182: ,p_action_information10 => 'D'
6183: ,p_action_information11 => 'C4'
6380: ,p_action_information3 => g_gre_id
6381: ,p_action_information4 => tab_liv_pe_data.pan_number
6382: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
6383: ,p_action_information6 => tab_liv_pe_data.full_name
6384: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
6385: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
6386: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
6387: ,p_action_information10 => 'NA'
6388: ,p_action_information11 => 'C5'
6430: ,p_action_information3 => g_gre_id
6431: ,p_action_information4 => tab_liv_pe_data.pan_number
6432: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
6433: ,p_action_information6 => tab_liv_pe_data.full_name
6434: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
6435: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
6436: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
6437: ,p_action_information10 => 'D'
6438: ,p_action_information11 => 'C4'
6522: ,p_action_information3 => g_gre_id
6523: ,p_action_information4 => tab_liv_pe_data.pan_number
6524: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
6525: ,p_action_information6 => tab_liv_pe_data.full_name
6526: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
6527: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
6528: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
6529: ,p_action_information10 => 'A'
6530: ,p_action_information11 => 'C4'