APPS.CSTPAPBR dependencies on WIP_REPETITIVE_SCHEDULES

Line 1274: FROM wip_repetitive_schedules wrs

1270: l_stmt_num := 10;
1271:
1272: SELECT MAX(wrs.repetitive_schedule_id)
1273: INTO l_rep_sched_id
1274: FROM wip_repetitive_schedules wrs
1275: WHERE wrs.line_id = i_ae_txn_rec.line_id;
1276:
1277: l_stmt_num := 15;
1278:

Line 1289: FROM wip_repetitive_schedules wrs

1285: l_acct_rec.mat_ovhd_account,
1286: l_acct_rec.res_account,
1287: l_acct_rec.ovhd_account,
1288: l_acct_rec.osp_account
1289: FROM wip_repetitive_schedules wrs
1290: WHERE wrs.repetitive_schedule_id = l_rep_sched_id;
1291:
1292: SELECT
1293: class_code

Line 9041: from wip_repetitive_schedules

9037:
9038: l_stmt_num := 60;
9039: select count(wip_entity_id) /* Changed for bug No 4586534 */
9040: into l_acct_exist
9041: from wip_repetitive_schedules
9042: where wip_entity_id = l_wip_entity_id
9043: and line_id = l_line_id
9044: and rownum < 2; /* 4586534 added rownum check as its only existence check */
9045:

Line 9058: from wip_repetitive_schedules

9054: 3, nvl(resource_account,-1),
9055: 4, nvl(outside_processing_account,-1),
9056: 5, nvl(overhead_account,-1))
9057: into o_acct_id1
9058: from wip_repetitive_schedules
9059: where wip_entity_id = l_wip_entity_id
9060: and line_id = l_line_id
9061: and rownum = 1;
9062: elsif l_entity_type = 4 then

Line 9311: -- If Job type is Repetitive then get from table WIP_REPETITIVE_SCHEDULES

9307: ------------------------------------------------------------------------------------------------
9308: l_stmt_num := 58;
9309: -------------------------------------------------------------------------
9310: -- Get the Variance Accounts based Job type
9311: -- If Job type is Repetitive then get from table WIP_REPETITIVE_SCHEDULES
9312: -- If Job type is Discrete then get from table WIP_DISCRETE_JOBS
9313: -------------------------------------------------------------------------
9314: IF ((i_ae_txn_rec.wip_entity_type = 1) OR (i_ae_txn_rec.wip_entity_type = 3)) THEN
9315:

Line 9332: FROM WIP_REPETITIVE_SCHEDULES

9328: 3, resource_variance_account,
9329: 4, outside_proc_variance_account,
9330: 5, overhead_variance_account)
9331: INTO l_ae_line_rec.account
9332: FROM WIP_REPETITIVE_SCHEDULES
9333: WHERE organization_id = i_ae_txn_rec.organization_id
9334: AND wip_entity_id = i_ae_txn_rec.txn_src_id;
9335: END IF;
9336: