APPS.CST_EAMCOST_PUB dependencies on ORG_ACCT_PERIODS

Line 1175: -- Get data from org_acct_periods if it is an open period.

1171: FND_MSG_PUB.ADD;
1172: RAISE FND_API.g_exc_error;
1173: END IF;
1174:
1175: -- Get data from org_acct_periods if it is an open period.
1176: BEGIN
1177: l_stmt_num := 300;
1178: SELECT acct_period_id,
1179: period_set_name,

Line 1187: FROM org_acct_periods

1183: l_period_id,
1184: l_period_set_name,
1185: l_period_name,
1186: l_period_start_date
1187: FROM org_acct_periods
1188: WHERE organization_id = p_org_id AND
1189: (acct_period_id = p_period_id OR
1190: (period_set_name = p_period_set_name AND
1191: period_name = p_period_name));

Line 3266: FROM org_acct_periods oap

3262: l_stmt_num := 25;
3263:
3264: SELECT count(*)
3265: INTO l_dummy
3266: FROM org_acct_periods oap
3267: WHERE oap.organization_id = l_organization_id
3268: AND l_trunc_le_sched_comp_date BETWEEN oap.period_start_date
3269: AND oap.schedule_close_date;
3270:

Line 3283: FROM org_acct_periods oap

3279: INTO l_acct_period_id,
3280: l_period_set_name,
3281: l_period_name,
3282: l_period_start_date
3283: FROM org_acct_periods oap
3284: WHERE oap.organization_id = l_organization_id
3285: AND l_trunc_le_sched_comp_date BETWEEN oap.period_start_date
3286: AND oap.schedule_close_date;
3287:

Line 5261: -- period_set_name in ORG_ACCT_PERIODS_V

5257: -- inventory_item_id in csi_item_instances
5258: -- p_serial_number IN VARCHAR2 Required
5259: -- serial_number in csi_item_instances
5260: -- p_period_set_name IN VARCHAR2 Required
5261: -- period_set_name in ORG_ACCT_PERIODS_V
5262: -- p_beginning_period_name IN VARCHAR2 Required
5263: -- starting period name for EAM cost Rollup
5264: -- p_ending_period_name IN VARCHAR2 Required
5265: -- ending period name for EAM Cost Rollup