DBA Data[Home] [Help]

APPS.CSTPGLXF dependencies on CST_PAC_PERIODS

Line 148: -- exist in cst_pac_periods for the le-ct

144:
145: ------------------------------------------------------------------
146: -- Validate Period
147: -- period should
148: -- exist in cst_pac_periods for the le-ct
149: -- should be closed
150: ------------------------------------------------------------------
151:
152: SELECT

Line 157: cst_pac_periods

153: count(*)
154: INTO
155: l_per_exists
156: FROM
157: cst_pac_periods
158: WHERE open_flag = 'N' AND
159: legal_entity = p_legal_entity AND
160: cost_type_id = p_cost_type_id AND
161: pac_period_id = p_period_id;

Line 220: cst_pac_periods

216: INTO
217: l_start_date,
218: l_end_date
219: FROM
220: cst_pac_periods
221: WHERE
222: pac_period_id = p_period_id;
223:
224: