DBA Data[Home] [Help]

APPS.BOM_OPRESOURCE_PVT dependencies on CST_ACTIVITIES

Line 66: from cst_activities

62: where resource_code = P_Code
63: and organization_id = P_OrgId;
64: cursor l_Activity_csr(P_Code varchar2, P_OrgId number) is
65: select activity_id
66: from cst_activities
67: where activity = P_Code
68: and nvl(organization_id, P_OrgId) = P_OrgId;
69: cursor l_defaults_csr(P_OpSeqId number, P_ResourceId number) is
70: select br.default_basis_type,

Line 369: from cst_activities ca,

365: Select 'x' dummy
366: From dual
367: Where not exists(
368: select null
369: from cst_activities ca,
370: bom_operation_sequences bos,
371: bom_operational_routings bor
372: where ca.activity_id = P_ActivityId
373: and bos.operation_sequence_id = P_OpSeqId