APPS.CST_EAMCOST_PUB dependencies on ORG_ACCT_PERIODS

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

949: FND_MSG_PUB.ADD;
950: RAISE FND_API.g_exc_error;
951: END IF;
952:
953: -- Get data from org_acct_periods if it is an open period.
954: BEGIN
955: l_stmt_num := 300;
956: SELECT acct_period_id,
957: period_set_name,

Line 965: FROM org_acct_periods

961: l_period_id,
962: l_period_set_name,
963: l_period_name,
964: l_period_start_date
965: FROM org_acct_periods
966: WHERE organization_id = p_org_id AND
967: (acct_period_id = p_period_id OR
968: (period_set_name = p_period_set_name AND
969: period_name = p_period_name));

Line 3044: FROM org_acct_periods oap

3040: l_stmt_num := 25;
3041:
3042: SELECT count(*)
3043: INTO l_dummy
3044: FROM org_acct_periods oap
3045: WHERE oap.organization_id = l_organization_id
3046: AND l_trunc_le_sched_comp_date BETWEEN oap.period_start_date
3047: AND oap.schedule_close_date;
3048:

Line 3061: FROM org_acct_periods oap

3057: INTO l_acct_period_id,
3058: l_period_set_name,
3059: l_period_name,
3060: l_period_start_date
3061: FROM org_acct_periods oap
3062: WHERE oap.organization_id = l_organization_id
3063: AND l_trunc_le_sched_comp_date BETWEEN oap.period_start_date
3064: AND oap.schedule_close_date;
3065:

Line 5039: -- period_set_name in ORG_ACCT_PERIODS_V

5035: -- inventory_item_id in csi_item_instances
5036: -- p_serial_number IN VARCHAR2 Required
5037: -- serial_number in csi_item_instances
5038: -- p_period_set_name IN VARCHAR2 Required
5039: -- period_set_name in ORG_ACCT_PERIODS_V
5040: -- p_beginning_period_name IN VARCHAR2 Required
5041: -- starting period name for EAM cost Rollup
5042: -- p_ending_period_name IN VARCHAR2 Required
5043: -- ending period name for EAM Cost Rollup