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 PAY_ACTION_INFORMATION

Line 37: l_string PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE ;

33: FUNCTION replace_comma(p_string IN VARCHAR2)
34: RETURN VARCHAR2
35: IS
36: l_procedure VARCHAR2(100);
37: l_string PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE ;
38: BEGIN
39:
40: g_debug := hr_utility.debug_enabled;
41: l_procedure := g_package ||'replace_comma';

Line 113: -- PAY_ACTION_INFORMATION --

109: -- Access : Public --
110: -- Description : This procedure creates the level 2 and 3 Data --
111: -- It generates the Employee Data i,e Personal Details,--
112: -- Employee Level Balances. It gets data from --
113: -- PAY_ACTION_INFORMATION --
114: -- Context : IN_PF_PERSON_DTLS --
115: -- IN_PF_SALARY --
116: -- --
117: -- Parameters : --

Line 150: l_term_efile PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE ;

146: l_tag VARCHAR2(1000);
147: l_procedure VARCHAR2(100);
148: l_hire_dd NUMBER ;
149: l_term_dd NUMBER ;
150: l_term_efile PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE ;
151: l_term_print_copy PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE ;
152: l_count NUMBER ;
153:
154: l_total_ncp NUMBER ;

Line 151: l_term_print_copy PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE ;

147: l_procedure VARCHAR2(100);
148: l_hire_dd NUMBER ;
149: l_term_dd NUMBER ;
150: l_term_efile PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE ;
151: l_term_print_copy PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE ;
152: l_count NUMBER ;
153:
154: l_total_ncp NUMBER ;
155: l_total_pf_wages NUMBER ;

Line 188: FROM pay_action_information

184: ,action_information10 efile_term_reason
185: ,action_information11 eps
186: ,action_information13 pf_class
187: ,action_context_id assignment_action_id
188: FROM pay_action_information
189: WHERE action_information2 = p_pf_arc_ref_no
190: AND action_information1 = p_business_number
191: AND action_information3 = p_month||p_year
192: AND action_information_category = 'IN_PF_PERSON_DTLS'

Line 205: FROM pay_action_information pai

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'
209: AND action_context_type = 'AAP'

Line 226: FROM pay_action_information

222: action_information21
223: ,action_information22
224: ,action_information23
225: ,action_information8
226: FROM pay_action_information
227: WHERE action_context_id = p_action_context_id
228: AND action_information1 = p_business_number
229: AND action_information_category = 'IN_PF_CHALLAN'
230: AND action_context_type = 'PA');

Line 238: FROM pay_action_information

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
239: WHERE action_context_id = p_action_context_id
240: AND action_information1 = p_business_number
241: AND action_information_category = 'IN_PF_CHALLAN'
242: AND action_context_type = 'PA'

Line 571: -- PAY_ACTION_INFORMATION --

567: -- Type : PROCEDURE --
568: -- Access : Public --
569: -- Description : This procedure creates the level 4 Data --
570: -- It generates the Challan Data.It gets data from --
571: -- PAY_ACTION_INFORMATION --
572: -- Context : IN_PF_CHALLAN --
573: -- --
574: -- --
575: -- Parameters : --

Line 620: FROM pay_action_information

616: ,action_information16 Dep_Branch_Name
617: ,action_information17 Dep_Branch_Address
618: ,action_information18 Base_Branch_Code
619: ,hr_general.decode_lookup('IN_PF_BASE_BRANCH',action_information18) Base_Branch_Name
620: FROM pay_action_information
621: WHERE action_context_id = p_action_context_id
622: AND action_information1 = p_business_number
623: AND action_information_category = 'IN_PF_CHALLAN'
624: AND action_context_type = 'PA';

Line 713: -- PAY_ACTION_INFORMATION --

709: -- Type : PROCEDURE --
710: -- Access : Public --
711: -- Description : This procedure creates the level 5 Data --
712: -- It generates the 14B Data.It gets data from --
713: -- PAY_ACTION_INFORMATION --
714: -- Context : IN_PF_CHALLAN --
715: -- IN_PF_14B --
716: -- --
717: -- Parameters : --

Line 741: FROM pay_action_information

737: CURSOR csr_challan
738: IS
739: SELECT DISTINCT
740: action_information8 Challan_Ref
741: FROM pay_action_information
742: WHERE action_context_id = p_action_context_id
743: AND action_information1 = p_business_number
744: AND action_information_category = 'IN_PF_CHALLAN'
745: AND action_context_type = 'PA';

Line 758: FROM pay_action_information

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'
762: AND action_context_type = 'PA';

Line 828: -- PAY_ACTION_INFORMATION --

824: -- Type : PROCEDURE --
825: -- Access : Public --
826: -- Description : This procedure creates the level 6 Data --
827: -- It generates the 7Q Data.It gets data from --
828: -- PAY_ACTION_INFORMATION --
829: -- Context : IN_PF_CHALLAN --
830: -- IN_PF_7Q --
831: -- --
832: -- Parameters : --

Line 856: FROM pay_action_information

852: CURSOR csr_challan
853: IS
854: SELECT DISTINCT
855: action_information8 Challan_Ref
856: FROM pay_action_information
857: WHERE action_context_id = p_action_context_id
858: AND action_information1 = p_business_number
859: AND action_information_category = 'IN_PF_CHALLAN'
860: AND action_context_type = 'PA';

Line 873: FROM pay_action_information

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'
877: AND action_context_type = 'PA';

Line 945: -- PAY_ACTION_INFORMATION --

941: -- Type : PROCEDURE --
942: -- Access : Public --
943: -- Description : This procedure creates the level 7 Data --
944: -- It generates the Misc Data.It gets data from --
945: -- PAY_ACTION_INFORMATION --
946: -- Context : IN_PF_CHALLAN --
947: -- IN_PF_MISC --
948: -- --
949: -- Parameters : --

Line 973: FROM pay_action_information

969: CURSOR csr_challan
970: IS
971: SELECT DISTINCT
972: action_information8 Challan_Ref
973: FROM pay_action_information
974: WHERE action_context_id = p_action_context_id
975: AND action_information1 = p_business_number
976: AND action_information_category = 'IN_PF_CHALLAN'
977: AND action_context_type = 'PA';

Line 992: FROM pay_action_information

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
995: AND action_information_category = 'IN_PF_MISC'
996: AND action_context_type = 'PA';

Line 1073: -- Gets the data from PAY_ACTION_INFORMATION --

1069: -- Access : Public --
1070: -- Description : This procedure creates the level 8 Data --
1071: -- It generates the data for the Representative --
1072: -- Details,Filer License Number --
1073: -- Gets the data from PAY_ACTION_INFORMATION --
1074: -- Context : IN_PF_ORG --
1075: -- Gets the data from HR_ORGANIZATION_INFORMATION --
1076: -- Context : PER_IN_COMPANY_FILER_INFO --
1077: -- --

Line 1102: l_filer_license_id PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;

1098:
1099: l_sys_date VARCHAR2(40);
1100: l_tag VARCHAR2(1000);
1101: l_procedure VARCHAR2(100) ;
1102: l_filer_license_id PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1103:
1104: CURSOR csr_filer_id
1105: IS
1106: SELECT org_information1

Line 1116: FROM pay_action_information

1112: IS
1113: SELECT DISTINCT
1114: action_information4 rep_name
1115: ,action_information5 rep_pos
1116: FROM pay_action_information
1117: WHERE action_information_category = 'IN_PF_ORG'
1118: AND action_context_type = 'PA'
1119: AND action_context_id = p_action_context_id
1120: AND action_information1 = p_business_number ;

Line 1188: -- Gets the data from PAY_ACTION_INFORMATION --

1184: -- Type : PROCEDURE --
1185: -- Access : Public --
1186: -- Description : This procedure creates the level 1 Data --
1187: -- It generates the data related to Business Number --
1188: -- Gets the data from PAY_ACTION_INFORMATION --
1189: -- Context : IN_PF_BUSINESS_NUMBER --
1190: -- Calls create_level2_3_xml --
1191: -- create_level4_xml --
1192: -- create_level5_xml --

Line 1225: l_pf_org PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;

1221: l_sys_date_time VARCHAR2(40);
1222: l_tag VARCHAR2(1000);
1223: l_procedure VARCHAR2(100);
1224:
1225: l_pf_org PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1226: l_ref_no PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1227: l_mth_yr PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1228: l_year PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1229: l_month PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;

Line 1226: l_ref_no PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;

1222: l_tag VARCHAR2(1000);
1223: l_procedure VARCHAR2(100);
1224:
1225: l_pf_org PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1226: l_ref_no PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1227: l_mth_yr PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1228: l_year PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1229: l_month PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1230: l_return_type PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;

Line 1227: l_mth_yr PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;

1223: l_procedure VARCHAR2(100);
1224:
1225: l_pf_org PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1226: l_ref_no PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1227: l_mth_yr PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1228: l_year PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1229: l_month PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1230: l_return_type PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1231: l_reg_comp_name PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;

Line 1228: l_year PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;

1224:
1225: l_pf_org PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1226: l_ref_no PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1227: l_mth_yr PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1228: l_year PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1229: l_month PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1230: l_return_type PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1231: l_reg_comp_name PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1232: l_business_no PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;

Line 1229: l_month PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;

1225: l_pf_org PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1226: l_ref_no PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1227: l_mth_yr PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1228: l_year PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1229: l_month PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1230: l_return_type PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1231: l_reg_comp_name PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1232: l_business_no PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1233: l_classification PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;

Line 1230: l_return_type PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;

1226: l_ref_no PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1227: l_mth_yr PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1228: l_year PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1229: l_month PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1230: l_return_type PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1231: l_reg_comp_name PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1232: l_business_no PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1233: l_classification PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1234: l_representative_name PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;

Line 1231: l_reg_comp_name PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;

1227: l_mth_yr PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1228: l_year PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1229: l_month PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1230: l_return_type PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1231: l_reg_comp_name PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1232: l_business_no PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1233: l_classification PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1234: l_representative_name PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1235: l_representative_desig PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;

Line 1232: l_business_no PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;

1228: l_year PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1229: l_month PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1230: l_return_type PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1231: l_reg_comp_name PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1232: l_business_no PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1233: l_classification PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1234: l_representative_name PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1235: l_representative_desig PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1236: l_action_context_id pay_action_information.action_context_id%TYPE;

Line 1233: l_classification PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;

1229: l_month PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1230: l_return_type PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1231: l_reg_comp_name PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1232: l_business_no PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1233: l_classification PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1234: l_representative_name PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1235: l_representative_desig PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1236: l_action_context_id pay_action_information.action_context_id%TYPE;
1237: l_pup PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;

Line 1234: l_representative_name PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;

1230: l_return_type PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1231: l_reg_comp_name PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1232: l_business_no PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1233: l_classification PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1234: l_representative_name PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1235: l_representative_desig PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1236: l_action_context_id pay_action_information.action_context_id%TYPE;
1237: l_pup PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1238:

Line 1235: l_representative_desig PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;

1231: l_reg_comp_name PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1232: l_business_no PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1233: l_classification PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1234: l_representative_name PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1235: l_representative_desig PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1236: l_action_context_id pay_action_information.action_context_id%TYPE;
1237: l_pup PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1238:
1239:

Line 1236: l_action_context_id pay_action_information.action_context_id%TYPE;

1232: l_business_no PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1233: l_classification PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1234: l_representative_name PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1235: l_representative_desig PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1236: l_action_context_id pay_action_information.action_context_id%TYPE;
1237: l_pup PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1238:
1239:
1240: l_total_ncp NUMBER ;

Line 1237: l_pup PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;

1233: l_classification PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1234: l_representative_name PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1235: l_representative_desig PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1236: l_action_context_id pay_action_information.action_context_id%TYPE;
1237: l_pup PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1238:
1239:
1240: l_total_ncp NUMBER ;
1241:

Line 1251: FROM pay_action_information

1247: ,action_information3 mth_yr
1248: ,action_information4 return_type
1249: ,action_information5 reg_comp_name
1250: ,action_context_id action_context_id
1251: FROM pay_action_information
1252: WHERE action_information2 = p_pf_arc_ref_no
1253: AND action_information1 = p_business_number
1254: AND action_information3 = p_month||p_year
1255: AND action_information_category = 'IN_PF_BUSINESS_NUMBER'

Line 1262: FROM pay_action_information pai,

1258: CURSOR csr_challan(p_action_context_id VARCHAR2)
1259: IS
1260: SELECT DISTINCT
1261: action_information20 pup
1262: FROM pay_action_information pai,
1263: pay_payroll_actions ppa
1264: WHERE pai.action_context_id = ppa.payroll_action_id
1265: AND ppa.action_type = 'X'
1266: AND ppa.action_status = 'C'

Line 1428: l_pf_org PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;

1424: l_message VARCHAR2(255);
1425: l_procedure VARCHAR2(100);
1426: l_tag VARCHAR2(1000);
1427:
1428: l_pf_org PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
1429: l_year NUMBER(4);
1430: l_month NUMBER(2);
1431:
1432: CURSOR csr_pf_bus_no(p_yr_mth VARCHAR2)

Line 1436: FROM pay_action_information pai,

1432: CURSOR csr_pf_bus_no(p_yr_mth VARCHAR2)
1433: IS
1434: SELECT DISTINCT
1435: pai.action_information1 bus_no
1436: FROM pay_action_information pai,
1437: pay_payroll_actions ppa
1438: WHERE pai.action_context_id = ppa.payroll_action_id
1439: AND ppa.action_type = 'X'
1440: AND ppa.action_status = 'C'