DBA Data[Home] [Help]

APPS.GMP_RSRC_AVL_PKG dependencies on CR_RSRC_DTL

Line 147: SELECT assigned_qty FROM cr_rsrc_dtl

143: )
144: ORDER BY from_time;
145:
146: CURSOR qty_c3 IS
147: SELECT assigned_qty FROM cr_rsrc_dtl
148: WHERE resource_id = p_resource_id;
149:
150: c INTEGER := 0;
151: u INTEGER ;

Line 667: FROM cr_rsrc_dtl

663: undetermined_calendar EXCEPTION ;
664:
665: CURSOR plant_cur is
666: SELECT organization_id, calendar_code
667: FROM cr_rsrc_dtl
668: WHERE resource_id = p_resource_id
669: AND delete_mark = 0
670: AND inactive_ind = 0 ;
671: