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.AHL_APPROVALS_PVT dependencies on HR_OPERATING_UNITS

Line 598: FROM HR_OPERATING_UNITS

594: FROM Ahl_Approval_Rules_vl
595: WHERE Approval_Rule_id = x_id);
596: CURSOR c_operating IS
597: SELECT ORGANIZATION_ID
598: FROM HR_OPERATING_UNITS
599: WHERE NAME = l_Approval_Rules_rec.OPERATING_NAME;
600:
601: -- Reema :
602: -- Added cursor for Application Usage Code

Line 852: FROM HR_OPERATING_UNITS

848: l_status VARCHAR2(30);
849: l_operating_unit NUMBER;
850: CURSOR c_operating IS
851: SELECT ORGANIZATION_ID
852: FROM HR_OPERATING_UNITS
853: WHERE NAME = l_Approval_Rules_rec.OPERATING_NAME;
854:
855: CURSOR CUR_STATUS IS
856: SELECT Status_code

Line 1260: AND operating_unit_id = (SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS WHERE NAME = p_Approval_Rules_rec.OPERATING_NAME)

1256:
1257: CURSOR check_active1 IS
1258: SELECT 1 FROM ahl_approval_rules_b
1259: WHERE UPPER(status_code) = 'ACTIVE'
1260: AND operating_unit_id = (SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS WHERE NAME = p_Approval_Rules_rec.OPERATING_NAME)
1261: AND approval_priority_code = p_Approval_Rules_rec.approval_priority_code
1262: AND application_usg_code = (SELECT application_usg_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1263: AND approval_object_code = (SELECT approval_object_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1264: AND approval_type_code = (SELECT approval_type_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)

Line 1270: AND operating_unit_id = (SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS WHERE NAME = p_Approval_Rules_rec.OPERATING_NAME)

1266:
1267: CURSOR check_active2 IS
1268: SELECT 1 FROM ahl_approval_rules_b
1269: WHERE UPPER(status_code) = 'ACTIVE'
1270: AND operating_unit_id = (SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS WHERE NAME = p_Approval_Rules_rec.OPERATING_NAME)
1271: AND approval_priority_code IS NULL
1272: AND application_usg_code = (SELECT application_usg_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1273: AND approval_object_code = (SELECT approval_object_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1274: AND approval_type_code IS NULL

Line 1396: SELECT 1 FROM HR_OPERATING_UNITS

1392: )
1393: IS
1394: l_count NUMBER;
1395: CURSOR chk_op_name IS
1396: SELECT 1 FROM HR_OPERATING_UNITS
1397: WHERE name = p_Approval_Rules_rec.operating_name;
1398: BEGIN
1399:
1400: OPEN chk_op_name;

Line 2139: SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS

2135: l_object VARCHAR2(30);
2136: l_type VARCHAR2(30);
2137:
2138: CURSOR c_operating IS
2139: SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS
2140: WHERE NAME = p_Approval_Rules_rec.OPERATING_NAME;
2141:
2142: CURSOR c_object IS
2143: SELECT approval_object_code FROM ahl_approval_rules_b