APPS.CST_PERIODIC_ABSORPTION_PROC dependencies on CST_LE_COST_TYPES

Line 1122: FROM cst_le_cost_types

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

Line 1309: FROM cst_le_cost_types clct

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

Line 1680: FROM cst_le_cost_types clct

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

Line 3704: FROM cst_le_cost_types

3700: -- optional process
3701:
3702: SELECT nvl(iteration_proc_flag,'N')
3703: INTO l_iteration_proc_flag
3704: FROM cst_le_cost_types
3705: WHERE legal_entity = p_legal_entity
3706: AND cost_type_id = p_cost_type_id;
3707:
3708: IF (p_run_options = 1 OR p_run_options = 2) THEN

Line 5098: , cst_le_cost_types clct

5094: SELECT
5095: ccg.cost_group_id cost_group_id
5096: , ccg.cost_group cost_group
5097: FROM cst_cost_groups ccg
5098: , cst_le_cost_types clct
5099: WHERE ccg.legal_entity = clct.legal_entity
5100: AND clct.legal_entity = p_legal_entity
5101: AND clct.cost_type_id = p_cost_type_id;
5102: