APPS.CSTPAPBR dependencies on WIP_REPETITIVE_SCHEDULES

Line 1056: FROM wip_repetitive_schedules wrs

1052: l_stmt_num := 10;
1053:
1054: SELECT MAX(wrs.repetitive_schedule_id)
1055: INTO l_rep_sched_id
1056: FROM wip_repetitive_schedules wrs
1057: WHERE wrs.line_id = i_ae_txn_rec.line_id;
1058:
1059: l_stmt_num := 15;
1060:

Line 1071: FROM wip_repetitive_schedules wrs

1067: l_acct_rec.mat_ovhd_account,
1068: l_acct_rec.res_account,
1069: l_acct_rec.ovhd_account,
1070: l_acct_rec.osp_account
1071: FROM wip_repetitive_schedules wrs
1072: WHERE wrs.repetitive_schedule_id = l_rep_sched_id;
1073:
1074: SELECT
1075: class_code

Line 8600: from wip_repetitive_schedules

8596:
8597: l_stmt_num := 60;
8598: select count(wip_entity_id) /* Changed for bug No 4586534 */
8599: into l_acct_exist
8600: from wip_repetitive_schedules
8601: where wip_entity_id = l_wip_entity_id
8602: and line_id = l_line_id
8603: and rownum < 2; /* 4586534 added rownum check as its only existence check */
8604:

Line 8617: from wip_repetitive_schedules

8613: 3, nvl(resource_account,-1),
8614: 4, nvl(outside_processing_account,-1),
8615: 5, nvl(overhead_account,-1))
8616: into o_acct_id1
8617: from wip_repetitive_schedules
8618: where wip_entity_id = l_wip_entity_id
8619: and line_id = l_line_id
8620: and rownum = 1;
8621: elsif l_entity_type = 4 then

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

8866: ------------------------------------------------------------------------------------------------
8867: l_stmt_num := 58;
8868: -------------------------------------------------------------------------
8869: -- Get the Variance Accounts based Job type
8870: -- If Job type is Repetitive then get from table WIP_REPETITIVE_SCHEDULES
8871: -- If Job type is Discrete then get from table WIP_DISCRETE_JOBS
8872: -------------------------------------------------------------------------
8873: IF (i_ae_txn_rec.wip_entity_type = 1) THEN
8874:

Line 8891: FROM WIP_REPETITIVE_SCHEDULES

8887: 3, resource_variance_account,
8888: 4, outside_proc_variance_account,
8889: 5, overhead_variance_account)
8890: INTO l_ae_line_rec.account
8891: FROM WIP_REPETITIVE_SCHEDULES
8892: WHERE organization_id = i_ae_txn_rec.organization_id
8893: AND wip_entity_id = i_ae_txn_rec.txn_src_id;
8894: END IF;
8895: