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 697: FROM cr_rsrc_dtl

693: undetermined_calendar EXCEPTION ;
694:
695: CURSOR plant_cur is
696: SELECT organization_id, calendar_code
697: FROM cr_rsrc_dtl
698: WHERE resource_id = p_resource_id
699: AND delete_mark = 0
700: AND inactive_ind = 0 ;
701: