APPS.CSTPGLXF dependencies on CST_LE_COST_TYPES

Line 76: -- exist in cst_le_cost_types

72:
73: -------------------------------------------------------------------
74: -- Validate the Legal Entity
75: -- the legal entity should
76: -- exist in cst_le_cost_types
77: -- post_to_gl flag for it should be 'Y'
78: -------------------------------------------------------------------
79:
80: SELECT

Line 85: cst_le_cost_types

81: count(*)
82: INTO
83: l_le_exists
84: FROM
85: cst_le_cost_types
86: WHERE
87: legal_entity = p_legal_entity AND
88: post_to_gl ='Y';
89:

Line 99: -- exist in cst_le_cost_types

95:
96: ------------------------------------------------------------------
97: -- Validate the Cost Type
98: -- cost type should
99: -- exist in cst_le_cost_types
100: -- post_to_gl flag for le-ct should be 'Y'
101: -- and the cost type should not be disabled
102: ------------------------------------------------------------------
103:

Line 109: cst_le_cost_types clct,

105: count(*)
106: INTO
107: l_ct_exists
108: FROM
109: cst_le_cost_types clct,
110: cst_cost_types cct
111: WHERE clct.legal_entity = p_legal_entity AND
112: clct.cost_type_id = p_cost_type_id AND
113: clct.post_to_gl = 'Y' AND

Line 181: cst_le_cost_types clct,

177: INTO
178: l_set_of_books_id,
179: l_sob_name
180: FROM
181: cst_le_cost_types clct,
182: gl_sets_of_books glsob
183: WHERE
184: clct.legal_entity = p_legal_entity AND
185: clct.cost_type_id = p_cost_type_id AND