200: different classifications under a Business Number.*/
201: CURSOR csr_assignment_bal(p_action_context_id VARCHAR2 ,p_pf_class varchar2)
202: IS
203: SELECT action_information3 bal_name
204: ,SUM (fnd_number.canonical_to_number(action_information4)) bal_value
205: FROM pay_action_information pai
206: WHERE action_context_id = p_action_context_id
207: AND action_information1 = p_business_number
208: AND action_information_category = 'IN_PF_SALARY'
214:
215:
216: CURSOR csr_challan
217: IS
218: SELECT SUM(fnd_number.canonical_to_number(action_information21)) Interest_on_Sec
219: ,SUM(fnd_number.canonical_to_number(action_information22)) Legal_Charges
220: ,SUM(fnd_number.canonical_to_number(action_information23)) Penalty
221: FROM (SELECT DISTINCT
222: action_information21
215:
216: CURSOR csr_challan
217: IS
218: SELECT SUM(fnd_number.canonical_to_number(action_information21)) Interest_on_Sec
219: ,SUM(fnd_number.canonical_to_number(action_information22)) Legal_Charges
220: ,SUM(fnd_number.canonical_to_number(action_information23)) Penalty
221: FROM (SELECT DISTINCT
222: action_information21
223: ,action_information22
216: CURSOR csr_challan
217: IS
218: SELECT SUM(fnd_number.canonical_to_number(action_information21)) Interest_on_Sec
219: ,SUM(fnd_number.canonical_to_number(action_information22)) Legal_Charges
220: ,SUM(fnd_number.canonical_to_number(action_information23)) Penalty
221: FROM (SELECT DISTINCT
222: action_information21
223: ,action_information22
224: ,action_information23
230: AND action_context_type = 'PA');
231:
232: CURSOR csr_pup_total_amount
233: IS
234: SELECT SUM(fnd_number.canonical_to_number(action_information7)) Payment_under_Protest
235: FROM (SELECT DISTINCT
236: action_information7
237: ,action_information8
238: FROM pay_action_information
603: action_information2 Payment_Type
604: ,action_information4 Cheque_DD_No
605: ,action_information5 Cheque_DD_Date
606: ,action_information6 Cheque_DD_Dep_Date
607: ,fnd_number.canonical_to_number(action_information7) Amount
608: ,action_information8 Challan_Ref
609: ,action_information9 Bank_Code
610: ,hr_general.decode_lookup('IN_PF_BANKS',action_information9) Bank_Name
611: ,action_information11 Branch_Code
749: SELECT DISTINCT
750: action_information1 Prev_Mth
751: ,action_information2 Prev_Yr
752: ,action_information3 Challan_Ref
753: ,fnd_number.canonical_to_number(action_information4) Penal_Damages_Due
754: ,fnd_number.canonical_to_number(action_information5) EPS_Penal_Damages
755: ,fnd_number.canonical_to_number(action_information6) EDLI_Penal_Damages
756: ,fnd_number.canonical_to_number(action_information7) EPF_Penal_Damages
757: ,fnd_number.canonical_to_number(action_information8) Edli_Admin
750: action_information1 Prev_Mth
751: ,action_information2 Prev_Yr
752: ,action_information3 Challan_Ref
753: ,fnd_number.canonical_to_number(action_information4) Penal_Damages_Due
754: ,fnd_number.canonical_to_number(action_information5) EPS_Penal_Damages
755: ,fnd_number.canonical_to_number(action_information6) EDLI_Penal_Damages
756: ,fnd_number.canonical_to_number(action_information7) EPF_Penal_Damages
757: ,fnd_number.canonical_to_number(action_information8) Edli_Admin
758: FROM pay_action_information
751: ,action_information2 Prev_Yr
752: ,action_information3 Challan_Ref
753: ,fnd_number.canonical_to_number(action_information4) Penal_Damages_Due
754: ,fnd_number.canonical_to_number(action_information5) EPS_Penal_Damages
755: ,fnd_number.canonical_to_number(action_information6) EDLI_Penal_Damages
756: ,fnd_number.canonical_to_number(action_information7) EPF_Penal_Damages
757: ,fnd_number.canonical_to_number(action_information8) Edli_Admin
758: FROM pay_action_information
759: WHERE action_context_id = p_action_context_id
752: ,action_information3 Challan_Ref
753: ,fnd_number.canonical_to_number(action_information4) Penal_Damages_Due
754: ,fnd_number.canonical_to_number(action_information5) EPS_Penal_Damages
755: ,fnd_number.canonical_to_number(action_information6) EDLI_Penal_Damages
756: ,fnd_number.canonical_to_number(action_information7) EPF_Penal_Damages
757: ,fnd_number.canonical_to_number(action_information8) Edli_Admin
758: FROM pay_action_information
759: WHERE action_context_id = p_action_context_id
760: AND action_information3 = p_challan
753: ,fnd_number.canonical_to_number(action_information4) Penal_Damages_Due
754: ,fnd_number.canonical_to_number(action_information5) EPS_Penal_Damages
755: ,fnd_number.canonical_to_number(action_information6) EDLI_Penal_Damages
756: ,fnd_number.canonical_to_number(action_information7) EPF_Penal_Damages
757: ,fnd_number.canonical_to_number(action_information8) Edli_Admin
758: FROM pay_action_information
759: WHERE action_context_id = p_action_context_id
760: AND action_information3 = p_challan
761: AND action_information_category = 'IN_PF_14B'
864: SELECT DISTINCT
865: action_information1 Due_Mth
866: ,action_information2 Due_Yr
867: ,action_information3 Challan_Ref
868: ,fnd_number.canonical_to_number(action_information4) EPF_Damages
869: ,fnd_number.canonical_to_number(action_information5) EPS_Damages
870: ,fnd_number.canonical_to_number(action_information6) EDLI_Damages
871: ,fnd_number.canonical_to_number(action_information7) EPF_Admin
872: ,fnd_number.canonical_to_number(action_information8) EDLI_Admin
865: action_information1 Due_Mth
866: ,action_information2 Due_Yr
867: ,action_information3 Challan_Ref
868: ,fnd_number.canonical_to_number(action_information4) EPF_Damages
869: ,fnd_number.canonical_to_number(action_information5) EPS_Damages
870: ,fnd_number.canonical_to_number(action_information6) EDLI_Damages
871: ,fnd_number.canonical_to_number(action_information7) EPF_Admin
872: ,fnd_number.canonical_to_number(action_information8) EDLI_Admin
873: FROM pay_action_information
866: ,action_information2 Due_Yr
867: ,action_information3 Challan_Ref
868: ,fnd_number.canonical_to_number(action_information4) EPF_Damages
869: ,fnd_number.canonical_to_number(action_information5) EPS_Damages
870: ,fnd_number.canonical_to_number(action_information6) EDLI_Damages
871: ,fnd_number.canonical_to_number(action_information7) EPF_Admin
872: ,fnd_number.canonical_to_number(action_information8) EDLI_Admin
873: FROM pay_action_information
874: WHERE action_context_id = p_action_context_id
867: ,action_information3 Challan_Ref
868: ,fnd_number.canonical_to_number(action_information4) EPF_Damages
869: ,fnd_number.canonical_to_number(action_information5) EPS_Damages
870: ,fnd_number.canonical_to_number(action_information6) EDLI_Damages
871: ,fnd_number.canonical_to_number(action_information7) EPF_Admin
872: ,fnd_number.canonical_to_number(action_information8) EDLI_Admin
873: FROM pay_action_information
874: WHERE action_context_id = p_action_context_id
875: AND action_information3 = p_challan
868: ,fnd_number.canonical_to_number(action_information4) EPF_Damages
869: ,fnd_number.canonical_to_number(action_information5) EPS_Damages
870: ,fnd_number.canonical_to_number(action_information6) EDLI_Damages
871: ,fnd_number.canonical_to_number(action_information7) EPF_Admin
872: ,fnd_number.canonical_to_number(action_information8) EDLI_Admin
873: FROM pay_action_information
874: WHERE action_context_id = p_action_context_id
875: AND action_information3 = p_challan
876: AND action_information_category = 'IN_PF_7Q'
978:
979: CURSOR csr_misc(p_challan VARCHAR2)
980: IS
981: SELECT DISTINCT
982: fnd_number.canonical_to_number(action_information2) EPF_Misc_Pay
983: ,action_information3 EPF_Rem
984: ,fnd_number.canonical_to_number(action_information4) EPS_Misc_Pay
985: ,action_information5 EPS_Rem
986: ,fnd_number.canonical_to_number(action_information6) EDLI_Misc_Pay
980: IS
981: SELECT DISTINCT
982: fnd_number.canonical_to_number(action_information2) EPF_Misc_Pay
983: ,action_information3 EPF_Rem
984: ,fnd_number.canonical_to_number(action_information4) EPS_Misc_Pay
985: ,action_information5 EPS_Rem
986: ,fnd_number.canonical_to_number(action_information6) EDLI_Misc_Pay
987: ,action_information7 EDLI_Rem
988: ,fnd_number.canonical_to_number(action_information8) EPF_Admin
982: fnd_number.canonical_to_number(action_information2) EPF_Misc_Pay
983: ,action_information3 EPF_Rem
984: ,fnd_number.canonical_to_number(action_information4) EPS_Misc_Pay
985: ,action_information5 EPS_Rem
986: ,fnd_number.canonical_to_number(action_information6) EDLI_Misc_Pay
987: ,action_information7 EDLI_Rem
988: ,fnd_number.canonical_to_number(action_information8) EPF_Admin
989: ,action_information9 EPF_Admin_Rem
990: ,fnd_number.canonical_to_number(action_information10) EDLI_Admin
984: ,fnd_number.canonical_to_number(action_information4) EPS_Misc_Pay
985: ,action_information5 EPS_Rem
986: ,fnd_number.canonical_to_number(action_information6) EDLI_Misc_Pay
987: ,action_information7 EDLI_Rem
988: ,fnd_number.canonical_to_number(action_information8) EPF_Admin
989: ,action_information9 EPF_Admin_Rem
990: ,fnd_number.canonical_to_number(action_information10) EDLI_Admin
991: ,action_information11 EDLI_Admin_Rem
992: FROM pay_action_information
986: ,fnd_number.canonical_to_number(action_information6) EDLI_Misc_Pay
987: ,action_information7 EDLI_Rem
988: ,fnd_number.canonical_to_number(action_information8) EPF_Admin
989: ,action_information9 EPF_Admin_Rem
990: ,fnd_number.canonical_to_number(action_information10) EDLI_Admin
991: ,action_information11 EDLI_Admin_Rem
992: FROM pay_action_information
993: WHERE action_context_id = p_action_context_id
994: AND action_information1 = p_challan