eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IN_PF_REPORTS dependencies on FND_NUMBER

Line 204: ,SUM (fnd_number.canonical_to_number(action_information4)) bal_value

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'

Line 218: SELECT SUM(fnd_number.canonical_to_number(action_information21)) Interest_on_Sec

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

Line 219: ,SUM(fnd_number.canonical_to_number(action_information22)) Legal_Charges

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

Line 220: ,SUM(fnd_number.canonical_to_number(action_information23)) Penalty

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

Line 234: SELECT SUM(fnd_number.canonical_to_number(action_information7)) Payment_under_Protest

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

Line 607: ,fnd_number.canonical_to_number(action_information7) Amount

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

Line 753: ,fnd_number.canonical_to_number(action_information4) Penal_Damages_Due

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

Line 754: ,fnd_number.canonical_to_number(action_information5) EPS_Penal_Damages

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

Line 755: ,fnd_number.canonical_to_number(action_information6) EDLI_Penal_Damages

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

Line 756: ,fnd_number.canonical_to_number(action_information7) EPF_Penal_Damages

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

Line 757: ,fnd_number.canonical_to_number(action_information8) Edli_Admin

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'

Line 868: ,fnd_number.canonical_to_number(action_information4) EPF_Damages

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

Line 869: ,fnd_number.canonical_to_number(action_information5) EPS_Damages

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

Line 870: ,fnd_number.canonical_to_number(action_information6) EDLI_Damages

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

Line 871: ,fnd_number.canonical_to_number(action_information7) EPF_Admin

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

Line 872: ,fnd_number.canonical_to_number(action_information8) EDLI_Admin

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'

Line 982: fnd_number.canonical_to_number(action_information2) EPF_Misc_Pay

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

Line 984: ,fnd_number.canonical_to_number(action_information4) EPS_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

Line 986: ,fnd_number.canonical_to_number(action_information6) EDLI_Misc_Pay

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

Line 988: ,fnd_number.canonical_to_number(action_information8) EPF_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

Line 990: ,fnd_number.canonical_to_number(action_information10) EDLI_Admin

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