APPS.AHL_PRD_RESOURCE_TRANX_PVT dependencies on BOM_DEPT_RES_INSTANCES

Line 70: FROM bom_dept_res_instances

66: c_resource_id NUMBER,
67: c_organization_id NUMBER)
68: IS
69: SELECT instance_id
70: FROM bom_dept_res_instances
71: WHERE department_id in (
72: select
73: distinct nvl(bodres.share_from_dept_id, bodres.department_id)
74: from

Line 97: FROM mtl_employees_current_view pf, bom_resource_employees bre, bom_dept_res_instances bdri

93: --p_emp_num in number) -- fix for bug# 6032288.
94: p_emp_num in varchar2)
95: IS
96: SELECT 'x'
97: FROM mtl_employees_current_view pf, bom_resource_employees bre, bom_dept_res_instances bdri
98: --, ahl_pp_requirement_v aprv
99: WHERE --aprv.department_id = bdri.department_id
100: --and aprv.RESOURCE_ID= bdri.resource_id
101: --and

Line 124: FROM bom_resource_employees bre, bom_dept_res_instances bdri --,

120: p_emp_id in number)
121:
122: IS
123: SELECT 'x'
124: FROM bom_resource_employees bre, bom_dept_res_instances bdri --,
125: --ahl_pp_requirement_v aprv
126: WHERE --aprv.department_id = bdri.department_id
127: --and aprv.RESOURCE_ID= bdri.resource_id
128: --and

Line 703: FROM bom_dept_res_instances

699: --Adithya commented out the following code as part of fix for bug# 6326254.
700: /* CURSOR get_instance_sernum (c_department_id NUMBER,c_serial_number VARCHAR2)
701: IS
702: SELECT instance_id
703: FROM bom_dept_res_instances
704: WHERE department_id = c_department_id
705: and Serial_Number=c_serial_number; */
706:
707: l_ctr NUMBER:=0;