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_EOY_REPORTS dependencies on PAY_ACTION_INFORMATION

Line 70: ( perq_value1 pay_action_information.action_information1%TYPE

66:
67: TYPE clob_tab_type IS TABLE OF CLOB INDEX BY BINARY_INTEGER;
68:
69: TYPE perq_record IS RECORD
70: ( perq_value1 pay_action_information.action_information1%TYPE
71: , perq_value2 pay_action_information.action_information1%TYPE
72: );
73:
74: TYPE t_perq_record is table of perq_record INDEX BY BINARY_INTEGER;

Line 71: , perq_value2 pay_action_information.action_information1%TYPE

67: TYPE clob_tab_type IS TABLE OF CLOB INDEX BY BINARY_INTEGER;
68:
69: TYPE perq_record IS RECORD
70: ( perq_value1 pay_action_information.action_information1%TYPE
71: , perq_value2 pay_action_information.action_information1%TYPE
72: );
73:
74: TYPE t_perq_record is table of perq_record INDEX BY BINARY_INTEGER;
75:

Line 175: , p_assessment_year IN pay_action_information.action_information3%TYPE

171: -- IN : p_gre_id NUMBER --
172: -- : p_assessment_year VARCHAR2 --
173: --------------------------------------------------------------------------
174: FUNCTION get_max_context_id ( p_gre_id IN hr_organization_units.organization_id%TYPE
175: , p_assessment_year IN pay_action_information.action_information3%TYPE
176: )
177: RETURN NUMBER
178: IS
179: --

Line 183: FROM pay_action_information pai

179: --
180: CURSOR csr_max_action_context_id
181: IS
182: SELECT MAX(pai.action_context_id)
183: FROM pay_action_information pai
184: WHERE pai.action_information_category ='IN_EOY_ORG'
185: AND pai.action_context_type = 'PA'
186: AND pai.Action_information1 = to_char(p_gre_id) /* Bug 11698592 */
187: AND pai.action_information3 = p_assessment_year;

Line 658: FROM pay_action_information

654: , NULL
655: , 'CITY') gre_place_value
656: ,'DIG_SIGN' dig_sign_name
657: ,Action_information22 dig_sign_value
658: FROM pay_action_information
659: WHERE action_context_id = p_action_context_id
660: AND action_information_category = 'IN_EOY_ORG'
661: AND action_information1 = to_char(p_gre_id)
662: AND ROWNUM =1;

Line 882: FROM pay_action_information pai

878: , 'EMP_PHONE' emp_phone
879: , action_information16 emp_phone_value
880: , 'EMP_EMAIL' emp_email
881: , action_information21 emp_email_value
882: FROM pay_action_information pai
883: WHERE pai.action_information_category = 'IN_EOY_PERSON'
884: AND pai.action_context_id = p_action_context_id
885: AND pai.source_id = p_source_id;
886:

Line 1091: FROM pay_action_information pai

1087: 'F16 Balance Tax',21,
1088: 'ER Paid Tax on Non Monetary Perquisite',22,
1089: 0) sort_index,
1090: action_information2 balance_value
1091: FROM pay_action_information pai
1092: WHERE action_information_category = 'IN_EOY_ASG_SAL'
1093: AND action_context_id = p_action_context_id
1094: AND source_id = p_source_id;
1095:

Line 1099: FROM pay_action_information pai

1095:
1096: CURSOR csr_prev_employment_tds
1097: IS
1098: SELECT 1
1099: FROM pay_action_information pai
1100: WHERE action_information_category = 'IN_EOY_ASG_SAL'
1101: AND action_context_id = p_action_context_id
1102: AND source_id = p_source_id
1103: AND action_information1 IN('TDS on Previous Employment',

Line 1108: CURSOR csr_other_components(p_action_information1 pay_action_information.action_information1%TYPE)

1104: 'CESS on Previous Employment',
1105: 'SC on Previous Employment');
1106:
1107:
1108: CURSOR csr_other_components(p_action_information1 pay_action_information.action_information1%TYPE)
1109: IS
1110: SELECT action_information2 balance_value
1111: FROM pay_action_information pai
1112: WHERE action_information_category = 'IN_EOY_ASG_SAL'

Line 1111: FROM pay_action_information pai

1107:
1108: CURSOR csr_other_components(p_action_information1 pay_action_information.action_information1%TYPE)
1109: IS
1110: SELECT action_information2 balance_value
1111: FROM pay_action_information pai
1112: WHERE action_information_category = 'IN_EOY_ASG_SAL'
1113: AND action_context_id = p_action_context_id
1114: AND source_id = p_source_id
1115: AND action_information1 = p_action_information1;

Line 1120: FROM pay_action_information pai

1116:
1117: CURSOR csr_other_income IS
1118: SELECT action_information1 balance_name,
1119: action_information2 balance_value
1120: FROM pay_action_information pai
1121: WHERE action_information_category = 'IN_EOY_ASG_SAL'
1122: AND action_context_id = p_action_context_id
1123: AND source_id = p_source_id
1124: AND action_information1 IN('Long Term Capital Gains',

Line 1137: FROM pay_action_information

1133: action_information2 Amt,
1134: action_information3 Std_Amt,
1135: action_information4 Taxable_Amt,
1136: action_information5 Std_Taxable_Amt
1137: FROM pay_action_information
1138: WHERE action_information_category = 'IN_EOY_ALLOW'
1139: AND action_context_id = p_action_context_id
1140: AND action_information1 <> 'Taxable Allowances'
1141: AND source_id =p_source_id;

Line 1180: FROM pay_action_information pai

1176: 'General Insurance Scheme','General Insurance Scheme',
1177: 'X')Description_Value
1178: , action_information2 Qualifying_Value
1179: , nvl(action_information3,action_information2) Gross_Value
1180: FROM pay_action_information pai
1181: WHERE action_information_category = 'IN_EOY_VIA'
1182: AND action_context_id = p_action_context_id
1183: AND NVL(action_information3,action_information2) > 0
1184: AND source_id =p_source_id

Line 1205: FROM pay_action_information pai

1201: 'F16 Deductions Sec 80CCF','80CCF',
1202: 'X')Description_Value
1203: , action_information2 Qualifying_Value
1204: , nvl(action_information3,action_information2) Gross_Value
1205: FROM pay_action_information pai
1206: WHERE action_information_category = 'IN_EOY_VIA'
1207: AND action_context_id = p_action_context_id
1208: AND NVL(action_information3,action_information2) > 0
1209: AND source_id =p_source_id

Line 1215: FROM pay_action_information pai

1211:
1212: /* Get Maxium assignment action of the run for each pay period of the tax year*/
1213: CURSOR csr_max_run_assact_period IS
1214: SELECT MAX(action_information4) run_assact
1215: FROM pay_action_information pai
1216: WHERE pai.action_information_category ='IN_EOY_ASG_SAL'
1217: AND pai.action_information1='Income Tax This Pay'
1218: AND pai.action_context_id = p_action_context_id
1219: AND pai.source_id = p_source_id

Line 1241: FROM pay_action_information

1237: '12',9,
1238: '01',10,
1239: '02',11,
1240: '03',12)sort_index
1241: FROM pay_action_information
1242: WHERE action_context_id = p_action_context_id
1243: AND source_id =p_source_id
1244: AND action_information_category = 'IN_EOY_ASG_SAL'
1245: AND action_information1= p_information

Line 1290: FROM pay_action_information pai

1286:
1287: CURSOR csr_tax_deposite_details (p_org_id number,p_action_id number,p_assignment_id number)
1288: IS
1289: SELECT nvl(sum(action_information9),0) Tax_Deposited
1290: FROM pay_action_information pai
1291: WHERE action_information_category ='IN_24Q_DEDUCTEE'
1292: AND action_context_type = 'AAP'
1293: AND action_information3 =p_org_id
1294: AND EXISTS (SELECT 1

Line 1303: FROM pay_action_information pai

1299:
1300: CURSOR csr_24QC_tax_deposite_details (p_org_id number,p_action_id number,p_assignment_id number)
1301: IS
1302: SELECT sum(action_information16 - action_information17) Tax_Deposited
1303: FROM pay_action_information pai
1304: WHERE action_information_category ='IN_24QC_DEDUCTEE'
1305: AND action_context_type = 'AAP'
1306: AND action_information3 =p_org_id
1307: AND EXISTS (SELECT 1

Line 1315: FROM pay_action_information pai

1311: AND paa.assignment_id = p_assignment_id);
1312:
1313: cursor csr_assignment_id is
1314: SELECT pai.assignment_id
1315: FROM pay_action_information pai
1316: WHERE pai.action_information_category ='IN_EOY_PERSON'
1317: AND action_context_id = p_action_context_id
1318: AND source_id = p_source_id;
1319:

Line 2015: FROM pay_action_information

2011: , 'Shares',16
2012: , 20) sort_index
2013: , SUM(NVL(action_information2,0)) value1
2014: , SUM(NVL(action_information3,0)) value2
2015: FROM pay_action_information
2016: WHERE action_information_category = 'IN_EOY_PERQ'
2017: AND action_context_id = p_action_context_id
2018: AND source_id =p_source_id
2019: GROUP BY DECODE(action_information1, 'Company Accommodation', 1

Line 2037: CURSOR csr_get_total_perq(p_action_information1 pay_action_information.action_information1%TYPE)

2033: , 'Employer Paid Tax',15
2034: , 'Shares',16
2035: , 20) ;
2036:
2037: CURSOR csr_get_total_perq(p_action_information1 pay_action_information.action_information1%TYPE)
2038: IS
2039: SELECT NVL(action_information2,0) value1
2040: FROM pay_action_information
2041: WHERE action_information_category = 'IN_EOY_PERQ'

Line 2040: FROM pay_action_information

2036:
2037: CURSOR csr_get_total_perq(p_action_information1 pay_action_information.action_information1%TYPE)
2038: IS
2039: SELECT NVL(action_information2,0) value1
2040: FROM pay_action_information
2041: WHERE action_information_category = 'IN_EOY_PERQ'
2042: AND action_context_id = p_action_context_id
2043: AND source_id =p_source_id
2044: AND action_information1 = p_action_information1;

Line 2221: FROM pay_action_information

2217: IS
2218: SELECT
2219: 'IMAGE_FILE1' image_form16_name
2220: ,Action_information23 image_form16_value
2221: FROM pay_action_information
2222: WHERE action_context_id = p_action_context_id
2223: AND action_information_category = 'IN_EOY_ORG'
2224: AND action_information1 = to_char(p_gre_id)
2225: AND ROWNUM =1;

Line 2317: FROM pay_action_information pai,

2313: AND hoi.org_information2 = 'Y'
2314: AND hou.organization_id = NVL(p_gre_id,hou.organization_id)
2315: AND hou.business_group_id = p_business_group_id
2316: AND EXISTS (SELECT 1
2317: FROM pay_action_information pai,
2318: pay_payroll_actions ppa
2319: WHERE pai.action_information_category = 'IN_EOY_ORG'
2320: AND pai.action_information1 = hou.organization_id
2321: AND pai.action_information3 = p_assessment_year

Line 2335: FROM pay_action_information pai

2331: IS
2332: SELECT MAX(pai.action_context_id) action_context_id
2333: , pai.action_information17 start_date
2334: , pai.action_information1 employee_number
2335: FROM pay_action_information pai
2336: ,per_assignments_f asg
2337: WHERE pai.action_information_category = 'IN_EOY_PERSON'
2338: AND asg.assignment_id = pai.assignment_id
2339: AND asg.business_group_id = p_business_group_id

Line 2356: FROM pay_action_information pai

2352: ,p_action_context_id NUMBER)
2353: IS
2354: SELECT pai.source_id Payroll_run_action_id
2355: ,pai.action_information18 end_date
2356: FROM pay_action_information pai
2357: WHERE pai.action_information_category ='IN_EOY_PERSON'
2358: AND pai.action_information17 = p_start_date
2359: AND pai.action_information1 = p_employee_number
2360: AND pai.action_information2 = p_assessment_year

Line 2574: FROM pay_action_information pai,

2570: AND hoi.org_information2 = 'Y'
2571: AND hou.organization_id = NVL(p_gre_id,hou.organization_id)
2572: AND hou.business_group_id = p_business_group_id
2573: AND EXISTS (SELECT 1
2574: FROM pay_action_information pai,
2575: pay_payroll_actions ppa
2576: WHERE pai.action_information_category = 'IN_EOY_ORG'
2577: AND pai.action_information1 = hou.organization_id
2578: AND pai.action_information3 = p_assessment_year

Line 2592: FROM pay_action_information pai

2588: IS
2589: SELECT MAX(pai.action_context_id) action_context_id
2590: , pai.action_information17 start_date
2591: , pai.action_information1 employee_number
2592: FROM pay_action_information pai
2593: ,per_assignments_f asg
2594: WHERE pai.action_information_category = 'IN_EOY_PERSON'
2595: AND asg.assignment_id = pai.assignment_id
2596: AND asg.business_group_id = p_business_group_id

Line 2614: FROM pay_action_information pai

2610: ,p_action_context_id NUMBER)
2611: IS
2612: SELECT pai.source_id Payroll_run_action_id
2613: ,pai.action_information18 end_date
2614: FROM pay_action_information pai
2615: WHERE pai.action_information_category ='IN_EOY_PERSON'
2616: AND pai.action_information17 = p_start_date
2617: AND pai.action_information1 = p_employee_number
2618: AND pai.action_information2 = p_assessment_year