APPS.CST_PERIODIC_ABSORPTION_PROC dependencies on CST_LE_COST_TYPES

Line 1124: FROM cst_le_cost_types

1120: nvl(max(pac_rates_cost_type_id),-1)
1121: , nvl(max(material_relief_algorithm),1)
1122: INTO l_pac_rates_id
1123: ,l_mat_relief_algorithm
1124: FROM cst_le_cost_types
1125: WHERE legal_entity = p_legal_entity
1126: AND cost_type_id = p_cost_type_id;
1127:
1128: x_pac_rates_id := l_pac_rates_id;

Line 1311: FROM cst_le_cost_types clct

1307: END IF;
1308:
1309: SELECT nvl(max(primary_cost_method),-1)
1310: INTO l_cost_method
1311: FROM cst_le_cost_types clct
1312: WHERE clct.legal_entity = p_legal_entity
1313: AND clct.cost_type_id = p_cost_type_id;
1314:
1315: x_cost_method := l_cost_method;

Line 1682: FROM cst_le_cost_types clct

1678: END IF;
1679:
1680: SELECT count(1)
1681: INTO l_count
1682: FROM cst_le_cost_types clct
1683: WHERE clct.legal_entity = p_legal_entity
1684: AND clct.cost_type_id = p_cost_type_id;
1685:
1686: IF l_count = 0

Line 3558: FROM cst_le_cost_types

3554: -- optional process
3555:
3556: SELECT nvl(iteration_proc_flag,'N')
3557: INTO l_iteration_proc_flag
3558: FROM cst_le_cost_types
3559: WHERE legal_entity = p_legal_entity
3560: AND cost_type_id = p_cost_type_id;
3561:
3562: IF (p_run_options = 1 OR p_run_options = 2) THEN

Line 4729: , cst_le_cost_types clct

4725: SELECT
4726: ccg.cost_group_id cost_group_id
4727: , ccg.cost_group cost_group
4728: FROM cst_cost_groups ccg
4729: , cst_le_cost_types clct
4730: WHERE ccg.legal_entity = clct.legal_entity
4731: AND clct.legal_entity = p_legal_entity
4732: AND clct.cost_type_id = p_cost_type_id;
4733: