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 75: ( perq_value1 pay_action_information.action_information1%TYPE

71:
72: TYPE clob_tab_type IS TABLE OF CLOB INDEX BY BINARY_INTEGER;
73:
74: TYPE perq_record IS RECORD
75: ( perq_value1 pay_action_information.action_information1%TYPE
76: , perq_value2 pay_action_information.action_information1%TYPE
77: );
78:
79: TYPE t_perq_record is table of perq_record INDEX BY BINARY_INTEGER;

Line 76: , perq_value2 pay_action_information.action_information1%TYPE

72: TYPE clob_tab_type IS TABLE OF CLOB INDEX BY BINARY_INTEGER;
73:
74: TYPE perq_record IS RECORD
75: ( perq_value1 pay_action_information.action_information1%TYPE
76: , perq_value2 pay_action_information.action_information1%TYPE
77: );
78:
79: TYPE t_perq_record is table of perq_record INDEX BY BINARY_INTEGER;
80:

Line 180: , p_assessment_year IN pay_action_information.action_information3%TYPE

176: -- IN : p_gre_id NUMBER --
177: -- : p_assessment_year VARCHAR2 --
178: --------------------------------------------------------------------------
179: FUNCTION get_max_context_id ( p_gre_id IN hr_organization_units.organization_id%TYPE
180: , p_assessment_year IN pay_action_information.action_information3%TYPE
181: )
182: RETURN NUMBER
183: IS
184: --

Line 188: FROM pay_action_information pai

184: --
185: CURSOR csr_max_action_context_id
186: IS
187: SELECT MAX(pai.action_context_id)
188: FROM pay_action_information pai
189: WHERE pai.action_information_category ='IN_EOY_ORG'
190: AND pai.action_context_type = 'PA'
191: AND pai.Action_information1 = p_gre_id
192: AND pai.action_information3 = p_assessment_year;

Line 526: FROM pay_action_information

522: , 'PLACE' gre_place
523: , pay_in_eoy_reports.get_location_details ( TO_NUMBER(action_information7)
524: , NULL
525: , 'CITY') gre_place_value
526: FROM pay_action_information
527: WHERE action_context_id = p_action_context_id
528: AND action_information_category = 'IN_EOY_ORG'
529: AND action_information1 = p_gre_id
530: AND ROWNUM =1;

Line 766: FROM pay_action_information pai

762: , assignment_id emp_asg_id
763: , action_information15 emp_resident_status
764: , 'EMP_PHONE' emp_phone
765: , action_information16 emp_phone_value
766: FROM pay_action_information pai
767: WHERE pai.action_information_category = 'IN_EOY_PERSON'
768: AND pai.action_context_id = p_action_context_id
769: AND pai.source_id = p_source_id;
770:

Line 959: FROM pay_action_information pai

955: 'F16 Balance Tax',21,
956: 'ER Paid Tax on Non Monetary Perquisite',22,
957: 0) sort_index,
958: action_information2 balance_value
959: FROM pay_action_information pai
960: WHERE action_information_category = 'IN_EOY_ASG_SAL'
961: AND action_context_id = p_action_context_id
962: AND source_id = p_source_id;
963:

Line 967: FROM pay_action_information pai

963:
964: CURSOR csr_prev_employment_tds
965: IS
966: SELECT 1
967: FROM pay_action_information pai
968: WHERE action_information_category = 'IN_EOY_ASG_SAL'
969: AND action_context_id = p_action_context_id
970: AND source_id = p_source_id
971: AND action_information1 IN('TDS on Previous Employment',

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

972: 'CESS on Previous Employment',
973: 'SC on Previous Employment');
974:
975:
976: CURSOR csr_other_components(p_action_information1 pay_action_information.action_information1%TYPE)
977: IS
978: SELECT action_information2 balance_value
979: FROM pay_action_information pai
980: WHERE action_information_category = 'IN_EOY_ASG_SAL'

Line 979: FROM pay_action_information pai

975:
976: CURSOR csr_other_components(p_action_information1 pay_action_information.action_information1%TYPE)
977: IS
978: SELECT action_information2 balance_value
979: FROM pay_action_information pai
980: WHERE action_information_category = 'IN_EOY_ASG_SAL'
981: AND action_context_id = p_action_context_id
982: AND source_id = p_source_id
983: AND action_information1 = p_action_information1;

Line 988: FROM pay_action_information pai

984:
985: CURSOR csr_other_income IS
986: SELECT action_information1 balance_name,
987: action_information2 balance_value
988: FROM pay_action_information pai
989: WHERE action_information_category = 'IN_EOY_ASG_SAL'
990: AND action_context_id = p_action_context_id
991: AND source_id = p_source_id
992: AND action_information1 IN('Long Term Capital Gains',

Line 1005: FROM pay_action_information

1001: action_information2 Amt,
1002: action_information3 Std_Amt,
1003: action_information4 Taxable_Amt,
1004: action_information5 Std_Taxable_Amt
1005: FROM pay_action_information
1006: WHERE action_information_category = 'IN_EOY_ALLOW'
1007: AND action_context_id = p_action_context_id
1008: AND action_information1 <> 'Taxable Allowances'
1009: AND source_id =p_source_id;

Line 1043: FROM pay_action_information pai

1039: 'Fixed Deposits','Fixed Deposits',
1040: 'X')Description_Value
1041: , action_information2 Qualifying_Value
1042: , nvl(action_information3,action_information2) Gross_Value
1043: FROM pay_action_information pai
1044: WHERE action_information_category = 'IN_EOY_VIA'
1045: AND action_context_id = p_action_context_id
1046: AND NVL(action_information3,action_information2) > 0
1047: AND source_id =p_source_id

Line 1067: FROM pay_action_information pai

1063: 'F16 Total Chapter VI A Deductions','TOTAL_V1A',
1064: 'X')Description_Value
1065: , action_information2 Qualifying_Value
1066: , nvl(action_information3,action_information2) Gross_Value
1067: FROM pay_action_information pai
1068: WHERE action_information_category = 'IN_EOY_VIA'
1069: AND action_context_id = p_action_context_id
1070: AND NVL(action_information3,action_information2) > 0
1071: AND source_id =p_source_id

Line 1077: FROM pay_action_information pai

1073:
1074: /* Get Maxium assignment action of the run for each pay period of the tax year*/
1075: CURSOR csr_max_run_assact_period IS
1076: SELECT MAX(action_information4) run_assact
1077: FROM pay_action_information pai
1078: WHERE pai.action_information_category ='IN_EOY_ASG_SAL'
1079: AND pai.action_information1='Income Tax This Pay'
1080: AND pai.action_context_id = p_action_context_id
1081: AND pai.source_id = p_source_id

Line 1103: FROM pay_action_information

1099: '12',9,
1100: '01',10,
1101: '02',11,
1102: '03',12)sort_index
1103: FROM pay_action_information
1104: WHERE action_context_id = p_action_context_id
1105: AND source_id =p_source_id
1106: AND action_information_category = 'IN_EOY_ASG_SAL'
1107: AND action_information1= p_information

Line 1768: FROM pay_action_information

1764: , 'Shares',16
1765: , 20) sort_index
1766: , SUM(NVL(action_information2,0)) value1
1767: , SUM(NVL(action_information3,0)) value2
1768: FROM pay_action_information
1769: WHERE action_information_category = 'IN_EOY_PERQ'
1770: AND action_context_id = p_action_context_id
1771: AND source_id =p_source_id
1772: GROUP BY DECODE(action_information1, 'Company Accommodation', 1

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

1786: , 'Employer Paid Tax',15
1787: , 'Shares',16
1788: , 20) ;
1789:
1790: CURSOR csr_get_total_perq(p_action_information1 pay_action_information.action_information1%TYPE)
1791: IS
1792: SELECT NVL(action_information2,0) value1
1793: FROM pay_action_information
1794: WHERE action_information_category = 'IN_EOY_PERQ'

Line 1793: FROM pay_action_information

1789:
1790: CURSOR csr_get_total_perq(p_action_information1 pay_action_information.action_information1%TYPE)
1791: IS
1792: SELECT NVL(action_information2,0) value1
1793: FROM pay_action_information
1794: WHERE action_information_category = 'IN_EOY_PERQ'
1795: AND action_context_id = p_action_context_id
1796: AND source_id =p_source_id
1797: AND action_information1 = p_action_information1;

Line 2014: FROM pay_action_information pai,

2010: AND hoi.org_information2 = 'Y'
2011: AND hou.organization_id = NVL(p_gre_id,hou.organization_id)
2012: AND hou.business_group_id = p_business_group_id
2013: AND EXISTS (SELECT 1
2014: FROM pay_action_information pai,
2015: pay_payroll_actions ppa
2016: WHERE pai.action_information_category = 'IN_EOY_ORG'
2017: AND pai.action_information1 = hou.organization_id
2018: AND pai.action_information3 = p_assessment_year

Line 2032: FROM pay_action_information pai

2028: IS
2029: SELECT MAX(pai.action_context_id) action_context_id
2030: , pai.action_information17 start_date
2031: , pai.action_information1 employee_number
2032: FROM pay_action_information pai
2033: ,per_assignments_f asg
2034: WHERE pai.action_information_category = 'IN_EOY_PERSON'
2035: AND asg.assignment_id = pai.assignment_id
2036: AND asg.business_group_id = p_business_group_id

Line 2053: FROM pay_action_information pai

2049: ,p_action_context_id NUMBER)
2050: IS
2051: SELECT pai.source_id Payroll_run_action_id
2052: ,pai.action_information18 end_date
2053: FROM pay_action_information pai
2054: WHERE pai.action_information_category ='IN_EOY_PERSON'
2055: AND pai.action_information17 = p_start_date
2056: AND pai.action_information1 = p_employee_number
2057: AND pai.action_information2 = p_assessment_year