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_SG_IRAS_AMEND_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 111: FROM hr_organization_information

107: decode(hr_assignment_set.ASSIGNMENT_IN_SET(c_assignment_set_id,pai.assignment_id),'Y','Y','N')) = 'Y'
108: and action_information2 between p_start_person_id and p_end_person_id
109: and action_information2 = nvl(c_person_id,action_information2)
110: and exists (SELECT 1
111: FROM hr_organization_information
112: WHERE org_information_context = 'SG_IRAS_DETAILS'
113: AND organization_id = g_legal_entity_id
114: AND org_information1 = g_basis_year);
115:

Line 123: FROM hr_organization_information

119: from pay_payroll_actions ppa,
120: pay_assignment_actions paa
121: where ppa.payroll_action_id in (
122: SELECT org_information2
123: FROM hr_organization_information
124: WHERE org_information_context = 'SG_IRAS_DETAILS'
125: AND organization_id = g_legal_entity_id
126: AND org_information1 = g_basis_year)
127: and ppa.payroll_action_id = paa.payroll_action_id

Line 235: from hr_organization_information,

231: ------------------------------------------------------------------------
232: cursor get_org_a8a_applicable
233: is
234: select org_information19
235: from hr_organization_information,
236: pay_payroll_actions
237: where org_information_context ='SG_LEGAL_ENTITY'
238: and organization_id = pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters)
239: and payroll_action_id = p_payroll_action_id;

Line 1559: FROM hr_organization_information

1555: AND arch.context1 IN( select paa.assignment_action_id -- ALL PREV ORIGINAL AND AMENDMENT ARCHIVES SUBMITTED B4
1556: from pay_payroll_actions ppa,
1557: pay_assignment_actions paa
1558: where ppa.payroll_action_id in (SELECT org_information2
1559: FROM hr_organization_information
1560: WHERE org_information_context = 'SG_IRAS_DETAILS'
1561: AND organization_id = g_legal_entity_id
1562: AND org_information1 = g_basis_year)
1563: and ppa.payroll_action_id = paa.payroll_action_id

Line 1663: FROM hr_organization_information

1659: and arch.context1 IN( select paa.assignment_action_id -- ALL PREV ORIGINAL AND AMENDMENT ARCHIVES SUBMITTED B4
1660: from pay_payroll_actions ppa,
1661: pay_assignment_actions paa
1662: where ppa.payroll_action_id in (SELECT org_information2
1663: FROM hr_organization_information
1664: WHERE org_information_context = 'SG_IRAS_DETAILS'
1665: AND organization_id = g_legal_entity_id
1666: AND org_information1 = g_basis_year)
1667: and ppa.payroll_action_id = paa.payroll_action_id

Line 1720: FROM hr_organization_information

1716: and arch.context1 IN( select paa.assignment_action_id -- ALL PREV ORIGINAL AND AMENDMENT ARCHIVES SUBMITTED B4
1717: from pay_payroll_actions ppa,
1718: pay_assignment_actions paa
1719: where ppa.payroll_action_id in (SELECT org_information2
1720: FROM hr_organization_information
1721: WHERE org_information_context = 'SG_IRAS_DETAILS'
1722: AND organization_id = g_legal_entity_id
1723: AND org_information1 = g_basis_year)
1724: and ppa.payroll_action_id = paa.payroll_action_id

Line 1793: FROM hr_organization_information

1789: -- ALL PREV ORIGINAL AND AMENDMENT ARCHIVES SUBMITTED B4
1790: from pay_payroll_actions ppa,
1791: pay_assignment_actions paa
1792: where ppa.payroll_action_id in (SELECT org_information2
1793: FROM hr_organization_information
1794: WHERE org_information_context = 'SG_IRAS_DETAILS'
1795: AND organization_id = g_legal_entity_id
1796: AND org_information1 = g_basis_year)
1797: and ppa.payroll_action_id = paa.payroll_action_id

Line 2142: FROM hr_organization_information

2138: -- ALL PREV ORIGINAL AND AMENDMENT ARCHIVES SUBMITTED B4
2139: from pay_payroll_actions ppa,
2140: pay_assignment_actions paa
2141: where ppa.payroll_action_id in (SELECT org_information2
2142: FROM hr_organization_information
2143: WHERE org_information_context = 'SG_IRAS_DETAILS'
2144: AND organization_id = g_legal_entity_id
2145: AND org_information1 = g_basis_year)
2146: and ppa.payroll_action_id = paa.payroll_action_id

Line 2286: v_er_incorp_date hr_organization_information.org_information9%type;

2282: amend_a8b_flag char(1);
2283: l_count number;
2284: v_er_incorp_date_1 char(10);
2285: v_er_incorp_date_2 char(10);
2286: v_er_incorp_date hr_organization_information.org_information9%type;
2287: v_archive char(1);
2288:
2289:
2290: ---------------------------------------------------------------------------

Line 2321: hr_organization_information hoi2,

2317: from per_all_people_f pap,
2318: per_people_extra_info pei,
2319: per_people_extra_info pei2,
2320: hr_all_organization_units hou,
2321: hr_organization_information hoi2,
2322: hr_organization_information hoi1
2323: where pap.person_id = c_person_id
2324: and pap.person_id = pei.person_id
2325: and pei.information_type = 'HR_STOCK_EXERCISE_SG'

Line 2322: hr_organization_information hoi1

2318: per_people_extra_info pei,
2319: per_people_extra_info pei2,
2320: hr_all_organization_units hou,
2321: hr_organization_information hoi2,
2322: hr_organization_information hoi1
2323: where pap.person_id = c_person_id
2324: and pap.person_id = pei.person_id
2325: and pei.information_type = 'HR_STOCK_EXERCISE_SG'
2326: and pap.person_id = pei2.person_id

Line 2356: FROM hr_organization_information

2352: from pay_payroll_actions ppa,
2353: pay_assignment_actions paa
2354: where ppa.payroll_action_id in (
2355: SELECT org_information2
2356: FROM hr_organization_information
2357: WHERE org_information_context = 'SG_IRAS_DETAILS'
2358: AND organization_id = g_legal_entity_id
2359: AND org_information1 = g_basis_year)
2360: and ppa.payroll_action_id = paa.payroll_action_id

Line 2420: FROM hr_organization_information

2416: from pay_payroll_actions ppa,
2417: pay_assignment_actions paa
2418: where ppa.payroll_action_id in (
2419: SELECT org_information2
2420: FROM hr_organization_information
2421: WHERE org_information_context = 'SG_IRAS_DETAILS'
2422: AND organization_id = g_legal_entity_id
2423: AND org_information1 = g_basis_year)
2424: and ppa.payroll_action_id = paa.payroll_action_id

Line 2468: FROM hr_organization_information

2464: from pay_payroll_actions ppa,
2465: pay_assignment_actions paa
2466: where ppa.payroll_action_id in (
2467: SELECT org_information2
2468: FROM hr_organization_information
2469: WHERE org_information_context = 'SG_IRAS_DETAILS'
2470: AND organization_id = g_legal_entity_id
2471: AND org_information1 = g_basis_year)
2472: and ppa.payroll_action_id = paa.payroll_action_id

Line 2513: FROM hr_organization_information

2509: -- ALL PREV ORIGINAL AND AMENDMENT ARCHIVES SUBMITTED B4
2510: from pay_payroll_actions ppa,
2511: pay_assignment_actions paa
2512: where ppa.payroll_action_id in (SELECT org_information2
2513: FROM hr_organization_information
2514: WHERE org_information_context = 'SG_IRAS_DETAILS'
2515: AND organization_id = g_legal_entity_id
2516: AND org_information1 = g_basis_year)
2517: and ppa.payroll_action_id = paa.payroll_action_id

Line 2568: FROM hr_organization_information

2564: from pay_payroll_actions ppa,
2565: pay_assignment_actions paa
2566: where ppa.payroll_action_id in (
2567: SELECT org_information2
2568: FROM hr_organization_information
2569: WHERE org_information_context = 'SG_IRAS_DETAILS'
2570: AND organization_id = g_legal_entity_id
2571: AND org_information1 = g_basis_year)
2572: and ppa.payroll_action_id = paa.payroll_action_id

Line 2936: FROM hr_organization_information

2932: from pay_payroll_actions ppa,
2933: pay_assignment_actions paa
2934: where ppa.payroll_action_id in (
2935: SELECT org_information2
2936: FROM hr_organization_information
2937: WHERE org_information_context = 'SG_IRAS_DETAILS'
2938: AND organization_id = g_legal_entity_id
2939: AND org_information1 = g_basis_year)
2940: and ppa.payroll_action_id = paa.payroll_action_id

Line 3005: FROM hr_organization_information

3001: from pay_payroll_actions ppa,
3002: pay_assignment_actions paa
3003: where ppa.payroll_action_id in (
3004: SELECT org_information2
3005: FROM hr_organization_information
3006: WHERE org_information_context = 'SG_IRAS_DETAILS'
3007: AND organization_id = g_legal_entity_id
3008: AND org_information1 = g_basis_year)
3009: and ppa.payroll_action_id = paa.payroll_action_id

Line 3060: FROM hr_organization_information

3056: -- ALL PREV ORIGINAL AND AMENDMENT ARCHIVES SUBMITTED B4
3057: from pay_payroll_actions ppa,
3058: pay_assignment_actions paa
3059: where ppa.payroll_action_id in (SELECT org_information2
3060: FROM hr_organization_information
3061: WHERE org_information_context = 'SG_IRAS_DETAILS'
3062: AND organization_id = g_legal_entity_id
3063: AND org_information1 = g_basis_year)
3064: and ppa.payroll_action_id = paa.payroll_action_id

Line 3139: FROM hr_organization_information

3135: from pay_payroll_actions ppa,
3136: pay_assignment_actions paa
3137: where ppa.payroll_action_id in (
3138: SELECT org_information2
3139: FROM hr_organization_information
3140: WHERE org_information_context = 'SG_IRAS_DETAILS'
3141: AND organization_id = g_legal_entity_id
3142: AND org_information1 = g_basis_year)
3143: and ppa.payroll_action_id = paa.payroll_action_id