APPS.GMF_LAYERS dependencies on GMF_PERIOD_STATUSES

Line 499: gmf_period_statuses gps,

495:
496: SELECT COUNT(*)
497: INTO l_period_count
498: FROM gmf_organization_definitions god,
499: gmf_period_statuses gps,
500: gmf_fiscal_policies gfp,
501: cm_mthd_mst mthd
502: WHERE god.organization_id = n.organization_id
503: AND gfp.legal_entity_id = god.legal_entity_id

Line 825: gmf_period_statuses gps,

821:
822: /* SELECT COUNT(*)
823: INTO l_period_count
824: FROM gmf_organization_definitions god,
825: gmf_period_statuses gps,
826: gmf_fiscal_policies gfp,
827: cm_mthd_mst mthd
828: WHERE god.organization_id = n.organization_id
829: AND gfp.legal_entity_id = god.legal_entity_id

Line 1220: from gmf_period_statuses

1216:
1217: BEGIN
1218:
1219: select start_date, end_date INTO l_start_date, l_end_date
1220: from gmf_period_statuses
1221: where period_id = p_period_id;
1222:
1223:
1224: DELETE

Line 1242: That is CONSUME_LAYER_DATE < (select start_date from gmf_period_statuses where period_id = p_period_id)

1238: /* Pseudo code
1239: Select all VIB details to be deleted. Vib details has these columns of interest.
1240: PROD_LAYER_ID (These will be deleted.) CONSUME_LAYER_ID ( Quantity needs to be added to this layer)
1241: CONSUME_LAYER_DATE ( Add quantity if CONSUME_LAYER_DATE is in a past period.
1242: That is CONSUME_LAYER_DATE < (select start_date from gmf_period_statuses where period_id = p_period_id)
1243: CONSUME_IB_DOC_QTY, CONSUME_IB_PRI_QTY.
1244: Quanity CONSUME_IB_DOC_QTY needs to be added to REMAINING_IB_DOC_QTY of gmf_outgoing_material_layers or gmf_resource_layers.
1245: Note that CONSUME_LAYER_ID could either belong to gmf_outgoing_material_layers or gmf_resource_layers.
1246: LINE_TYPE will decide whether it is outgoing layer or resource layer.

Line 1452: from gmf_period_statuses

1448:
1449: l_trans_rec GMF_LAYERS.TRANS_REC_TYPE;
1450: BEGIN
1451: select start_date, end_date INTO l_start_date, l_end_date
1452: from gmf_period_statuses
1453: where period_id = p_period_id;
1454:
1455: GMF_LAYERS.log_message (
1456: p_table_name => 'GMF_BATCH_VIB_DETAILS',

Line 1711: from gmf_period_statuses

1707: l_trans_rec GMF_LAYERS.TRANS_REC_TYPE;
1708: BEGIN
1709:
1710: select start_date, end_date INTO l_start_date, l_end_date
1711: from gmf_period_statuses
1712: where period_id = p_period_id;
1713:
1714: GMF_LAYERS.log_message (
1715: p_table_name => 'GMF_BATCH_VIB_DETAILS',

Line 1898: from gmf_period_statuses

1894: l_trans_rec GMF_LAYERS.TRANS_REC_TYPE;
1895: BEGIN
1896:
1897: select start_date, end_date INTO l_start_date, l_end_date
1898: from gmf_period_statuses
1899: where period_id = p_period_id;
1900:
1901: l_use_vib := FND_PROFILE.VALUE ('GMF_USE_VIB_FOR_ACOST');
1902: l_use_step_dep := FND_PROFILE.VALUE ('GMF_USE_ITEM_STEP_DEPENDENCIES');

Line 2143: from gmf_period_statuses

2139: AND b.batch_close_date <= l_end_date;
2140: BEGIN
2141:
2142: select start_date, end_date INTO l_start_date, l_end_date
2143: from gmf_period_statuses
2144: where period_id = p_period_id;
2145:
2146: FOR cls IN c_mig_closed_batches LOOP
2147: BEGIN

Line 2256: FROM gmf_period_statuses gps

2252: CURSOR cur_get_periodid IS
2253: SELECT gps.period_id,
2254: gps.start_date,
2255: gps.end_date
2256: FROM gmf_period_statuses gps
2257: WHERE gps.cost_type_id = l_cost_type
2258: AND gps.calendar_code = l_calendar
2259: AND gps.period_code = l_period
2260: AND gps.legal_entity_id = l_legal_entity_id;