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.PA_ORG_UTILS dependencies on HR_ORGANIZATION_INFORMATION

Line 138: from pa_implementations imp,hr_organization_information hr

134: ,'EXPENDITURES',EXP_ORG_STRUCTURE_VERSION_ID
135: ,'REPORTING',ORG_STRUCTURE_VERSION_ID
136: ,'BURDENING',to_number(org_information2))
137: into x_org_version_id
138: from pa_implementations imp,hr_organization_information hr
139: where imp.business_group_id = hr.organization_id
140: and hr.org_information_context = 'Project Burdening Hierarchy';
141: RETURN (x_org_version_id);
142: EXCEPTION when no_data_found then

Line 174: ,hr_organization_information c

170: else
171: select distinct organization_id_parent into x_start_org_id
172: from per_org_structure_elements a
173: ,pa_implementations b
174: ,hr_organization_information c
175: where organization_id_parent not in
176: ( select d.ORGANIZATION_ID_CHILD from per_org_structure_elements d
177: where d.org_structure_version_id = to_number(c.org_information2)
178: )

Line 301: from hr_organization_information info

297: ,'PROJECTS'
298: from per_org_structure_elements se
299: where org_structure_version_id = x_new_proj_org_version_id
300: AND EXISTS (select 'X'
301: from hr_organization_information info
302: where info.organization_id = se.organization_id_child
303: and info.org_information1 = 'PA_PROJECT_ORG'
304: and info.org_information_context||'' = 'CLASS'
305: and info.org_information2 = 'Y')

Line 317: from hr_organization_information info

313: ,x_org_id
314: ,'PROJECTS'
315: from sys.duaL /* Exists clause added for bug#2591146 */
316: where EXISTS (select 'X'
317: from hr_organization_information info
318: where info.organization_id = x_new_proj_start_org_id
319: and info.org_information1 = 'PA_PROJECT_ORG'
320: and info.org_information_context||'' = 'CLASS'
321: and info.org_information2 = 'Y')

Line 367: from hr_organization_information

363: fetch c_get_sub_orgs into l_child_org_id;
364: exit when c_get_sub_orgs%notfound;
365: begin
366: select 'YES' into proj_org_true
367: from hr_organization_information
368: where organization_id = l_child_org_id
369: and ORG_INFORMATION_CONTEXT = 'CLASS'
370: and ORG_INFORMATION1 = 'PA_PROJECT_ORG'
371: and ORG_INFORMATION2 = 'Y';

Line 411: from hr_organization_information info

407: ,'EXPENDITURES'
408: from per_org_structure_elements se
409: where org_structure_version_id = x_new_exp_org_version_id
410: AND EXISTS (select 'X'
411: from hr_organization_information info
412: where info.organization_id = se.organization_id_child
413: and info.org_information1 = 'PA_EXPENDITURE_ORG'
414: and info.org_information_context||'' = 'CLASS'
415: and info.org_information2 = 'Y')

Line 427: from hr_organization_information info

423: ,x_org_id
424: ,'EXPENDITURES'
425: from sys.duaL /* Exists clause added for bug#2591146 */
426: where EXISTS (select 'X'
427: from hr_organization_information info
428: where info.organization_id = x_new_exp_start_org_id
429: and info.org_information1 = 'PA_EXPENDITURE_ORG'
430: and info.org_information_context||'' = 'CLASS'
431: and info.org_information2 = 'Y')

Line 475: from hr_organization_information

471: fetch c_get_sub_orgs into l_child_org_id;
472: exit when c_get_sub_orgs%notfound;
473: begin
474: select 'YES' into exp_org_true
475: from hr_organization_information
476: where organization_id = l_child_org_id
477: and ORG_INFORMATION_CONTEXT = 'CLASS'
478: and ORG_INFORMATION1 = 'PA_EXPENDITURE_ORG'
479: and ORG_INFORMATION2 = 'Y';

Line 893: from hr_organization_information info

889: imp_rec.org_id,
890: 'PROJECTS'
891: from sys.dual
892: where exists (select 'x'
893: from hr_organization_information info
894: where info.organization_id = x_organization_id_child
895: and info.org_information1 = 'PA_PROJECT_ORG'
896: and info.org_information_context||'' = 'CLASS'
897: and info.org_information2 = 'Y')

Line 914: from hr_organization_information info

910: where organization_id = x_organization_id_child
911: and org_id = imp_rec.org_id --MOAC Changes: Bug 4363092: Removed nvl usage with org_id
912: and pa_org_use_type = 'PROJECTS'
913: and exists (select 'x' -- EXISTS condition added for bug 2890516
914: from hr_organization_information info
915: where info.organization_id = x_organization_id_child
916: and info.org_information1 = 'PA_PROJECT_ORG'
917: and info.org_information_context||'' = 'CLASS'
918: and info.org_information2 = 'Y');

Line 933: from hr_organization_information info

929: exit when get_all_orgs%notfound;
930:
931: begin
932: select 'Y' into l_proj_org_true
933: from hr_organization_information info
934: where info.organization_id = x_organization_id_child
935: and info.org_information1 = 'PA_PROJECT_ORG'
936: and info.org_information_context||'' = 'CLASS'
937: and info.org_information2 = 'Y';

Line 1005: from hr_organization_information info

1001: imp_rec.org_id,
1002: 'EXPENDITURES'
1003: from sys.dual
1004: where exists (select 'x'
1005: from hr_organization_information info
1006: where info.organization_id = x_organization_id_child
1007: and info.org_information1 = 'PA_EXPENDITURE_ORG'
1008: and info.org_information_context||'' = 'CLASS'
1009: and info.org_information2 = 'Y')

Line 1026: from hr_organization_information info

1022: where organization_id =x_organization_id_child
1023: and org_id = imp_rec.org_id --MOAC Changes: Bug 4363092: Removed nvl usage with org_id
1024: and pa_org_use_type = 'EXPENDITURES'
1025: and exists (select 'x' -- EXISTS condition added for bug 2890516
1026: from hr_organization_information info
1027: where info.organization_id = x_organization_id_child
1028: and info.org_information1 = 'PA_EXPENDITURE_ORG'
1029: and info.org_information_context||'' = 'CLASS'
1030: and info.org_information2 = 'Y');

Line 1042: from hr_organization_information info

1038: exit when get_all_orgs%notfound;
1039:
1040: begin
1041: select 'Y' into l_exp_org_true
1042: from hr_organization_information info
1043: where info.organization_id = x_organization_id_child
1044: and info.org_information1 = 'PA_EXPENDITURE_ORG'
1045: and info.org_information_context||'' = 'CLASS'
1046: and info.org_information2 = 'Y';

Line 1215: -----maintain_org_info_hist_bri created on HR_ORGANIZATION_INFORMATION

1211:
1212: End;
1213:
1214:
1215: -----maintain_org_info_hist_bri created on HR_ORGANIZATION_INFORMATION
1216: ----- For update and insert in PA_ALL_ORGANIZATIO against BUG NO 1357522
1217: procedure maintain_org_info_hist_bri
1218: (x_organization_id in number ,
1219: x_org_information1 in varchar2,

Line 1567: from hr_organization_information info

1563: SELECT se.organization_id_child organization_id
1564: FROM per_org_structure_elements se
1565: WHERE org_structure_version_id = x_new_org_version_id
1566: AND EXISTS (select 'X'
1567: from hr_organization_information info
1568: where info.organization_id = se.organization_id_child
1569: and info.org_information1 = 'PA_PROJECT_ORG'
1570: and info.org_information_context||'' = 'CLASS'
1571: and info.org_information2 = 'Y')

Line 1580: from hr_organization_information info

1576: AND org_structure_version_id = x_new_org_version_id
1577: UNION
1578: SELECT x_new_start_org_id FROM Sys.dual -- Added exists clause for Bug# 1650520
1579: WHERE EXISTS (select 'X'
1580: from hr_organization_information info
1581: where info.org_information1 = 'PA_PROJECT_ORG'
1582: and info.org_information_context||'' = 'CLASS'
1583: and info.org_information2 = 'Y'
1584: and info.organization_id = x_new_start_org_id);

Line 1592: from hr_organization_information info

1588: SELECT se.organization_id_child organization_id
1589: FROM per_org_structure_elements se
1590: WHERE org_structure_version_id = x_new_org_version_id
1591: AND EXISTS (select 'X'
1592: from hr_organization_information info
1593: where info.organization_id = se.organization_id_child
1594: and info.org_information1 = 'PA_EXPENDITURE_ORG'
1595: and info.org_information_context||'' = 'CLASS'
1596: and info.org_information2 = 'Y')

Line 1605: from hr_organization_information info

1601: AND org_structure_version_id = x_new_org_version_id
1602: UNION
1603: SELECT x_new_start_org_id FROM Sys.dual
1604: where EXISTS (select 'X' /* Made changes for BUG 1180635*/
1605: from hr_organization_information info
1606: where info.org_information1 = 'PA_EXPENDITURE_ORG'
1607: and info.org_information_context||'' = 'CLASS'
1608: and info.org_information2 = 'Y'
1609: and info.organization_id = x_new_start_org_id);

Line 3498: FROM hr_organization_information

3494: FETCH c_get_sub_orgs INTO l_child_org_id;
3495: EXIT WHEN c_get_sub_orgs%NOTFOUND;
3496: BEGIN
3497: SELECT 'YES' INTO class_org_true
3498: FROM hr_organization_information
3499: WHERE organization_id = l_child_org_id
3500: AND ORG_INFORMATION_CONTEXT = 'CLASS'
3501: AND ORG_INFORMATION1 = decode(p_org_use_type, 'PROJECTS', 'PA_PROJECT_ORG',
3502: 'EXPENDITURES', 'PA_EXPENDITURE_ORG')

Line 3543: from hr_organization_information info

3539: SELECT se.organization_id_child organization_id
3540: FROM per_org_structure_elements se
3541: WHERE org_structure_version_id = x_org_version_id
3542: AND EXISTS (select 'X'
3543: from hr_organization_information info
3544: where info.organization_id = se.organization_id_child
3545: and info.org_information1 = 'PA_PROJECT_ORG'
3546: and info.org_information_context||'' = 'CLASS'
3547: and info.org_information2 = 'Y')

Line 3556: from hr_organization_information info

3552: AND org_structure_version_id = x_org_version_id
3553: UNION
3554: SELECT v_start_org_id FROM Sys.dual -- Added exists clause for Bug# 1650520
3555: WHERE EXISTS (select 'X'
3556: from hr_organization_information info
3557: where info.org_information1 = 'PA_PROJECT_ORG'
3558: and info.org_information_context||'' = 'CLASS'
3559: and info.org_information2 = 'Y'
3560: and info.organization_id = v_start_org_id);

Line 3567: from hr_organization_information info

3563: SELECT se.organization_id_child organization_id
3564: FROM per_org_structure_elements se
3565: WHERE org_structure_version_id = x_org_version_id
3566: AND EXISTS (select 'X'
3567: from hr_organization_information info
3568: where info.organization_id = se.organization_id_child
3569: and info.org_information1 = 'PA_EXPENDITURE_ORG'
3570: and info.org_information_context||'' = 'CLASS'
3571: and info.org_information2 = 'Y')

Line 3580: from hr_organization_information info

3576: AND org_structure_version_id = x_org_version_id
3577: UNION
3578: SELECT v_start_org_id FROM Sys.dual
3579: where EXISTS (select 'X' /* Made changes for BUG 1180635*/
3580: from hr_organization_information info
3581: where info.org_information1 = 'PA_EXPENDITURE_ORG'
3582: and info.org_information_context||'' = 'CLASS'
3583: and info.org_information2 = 'Y'
3584: and info.organization_id = v_start_org_id);