APPS.ASO_APR_INT dependencies on ASO_APR_OBJ_APPROVALS

Line 636: FROM aso_apr_obj_approvals

632: ) + 1
633: ),
634: 1
635: )
636: FROM aso_apr_obj_approvals
637: WHERE object_id = c_object_id;
638:
639: cursor get_employee_id(l_user_id NUMBER) IS
640: select employee_id

Line 646: FROM aso_apr_obj_approvals

642: where user_id = l_user_id;
643:
644: CURSOR C_get_duplicate_approval IS
645: SELECT count(*)
646: FROM aso_apr_obj_approvals
647: WHERE object_id = p_object_id
648: AND approval_status = 'PEND';
649:
650:

Line 1189: update aso_apr_obj_approvals

1185:
1186: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1187: aso_debug_pub.ADD ('Self Approval Case: Updating to Approved',1,'N');
1188: END IF;
1189: update aso_apr_obj_approvals
1190: set approval_status = 'APPR',
1191: end_date = sysdate
1192: where object_approval_id = p_object_approval_id;
1193: END IF;

Line 1331: FROM aso_apr_obj_approvals

1327: c_object_id NUMBER,
1328: c_object_type VARCHAR2
1329: ) IS
1330: SELECT object_approval_id
1331: FROM aso_apr_obj_approvals
1332: WHERE object_id = c_object_id
1333: AND object_type = c_object_type
1334: AND approval_instance_id = (SELECT MAX (
1335: approval_instance_id

Line 1337: FROM aso_apr_obj_approvals

1333: AND object_type = c_object_type
1334: AND approval_instance_id = (SELECT MAX (
1335: approval_instance_id
1336: )
1337: FROM aso_apr_obj_approvals
1338: WHERE object_id = c_object_id
1339: AND object_type = c_object_type);
1340: BEGIN
1341: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN