APPS.AHL_PP_RESRC_ASSIGN_PVT dependencies on AHL_PP_REQUIREMENT_V

Line 189: ahl_pp_requirement_v aprv

185: bdr.department_id)
186: FROM
187: bom_departments bd,
188: bom_department_resources bdr,
189: ahl_pp_requirement_v aprv
190: WHERE
191: bdr.resource_id = p_resource_id and
192: bdr.department_id = bd.department_id and
193: bd.organization_id = p_organization_id

Line 1027: SELECT requirement_id, operation_id, resource_id FROM AHL_PP_REQUIREMENT_V

1023: FROM AHL_WORK_ASSIGNMENTS
1024: WHERE ASSIGNMENT_ID = x_id);
1025:
1026: /*CURSOR c_oper_resrc (x_id IN NUMBER, x_oper IN NUMBER, x_resrc IN NUMBER) IS
1027: SELECT requirement_id, operation_id, resource_id FROM AHL_PP_REQUIREMENT_V
1028: WHERE job_id = x_id
1029: AND resource_sequence = x_resrc
1030: AND operation_sequence = x_oper;
1031: */

Line 1049: AHL_PP_REQUIREMENT_V

1045:
1046: /*
1047: CURSOR c_resource (x_oper IN NUMBER, x_res IN NUMBER, x_id IN NUMBER) IS
1048: SELECT RESOURCE_TYPE_CODE FROM
1049: AHL_PP_REQUIREMENT_V
1050: WHERE OPERATION_SEQUENCE = x_oper AND RESOURCE_SEQUENCE = x_res
1051: AND JOB_ID = x_id;
1052: */
1053: --Modified by Srini for performance fix

Line 1067: SELECT resource_id FROM AHL_PP_REQUIREMENT_V

1063: AND WOP.workorder_id = x_id;
1064:
1065: /*
1066: CURSOR c_assign (x_id IN NUMBER, x_oper IN NUMBER, x_resrc IN NUMBER) IS
1067: SELECT resource_id FROM AHL_PP_REQUIREMENT_V
1068: WHERE job_id = x_id
1069: AND resource_sequence = x_resrc
1070: AND operation_sequence = x_oper;
1071: */

Line 2034: SELECT resource_id FROM AHL_PP_REQUIREMENT_V

2030:
2031: c_resource_rec c_resource%ROWTYPE;
2032:
2033: /*CURSOR c_assign1 (x_id IN NUMBER, x_oper IN NUMBER, x_resrc IN NUMBER) IS
2034: SELECT resource_id FROM AHL_PP_REQUIREMENT_V
2035: WHERE job_id = x_id
2036: AND resource_sequence = x_resrc
2037: AND operation_sequence = x_oper;
2038: */