eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FEM_DIMENSION_UTIL_PKG dependencies on FEM_CAL_PERIODS_ATTR

Line 1436: v_sql := v_sql||',fem_cal_periods_attr CPA';

1432:
1433: v_sql := 'SELECT CP.cal_period_id FROM fem_cal_periods_b CP';
1434:
1435: IF v_incl_adj_period = 'N' THEN
1436: v_sql := v_sql||',fem_cal_periods_attr CPA';
1437: END IF;
1438:
1439: v_sql := v_sql||' WHERE CP.calendar_id=:1'
1440: || ' AND CP.dimension_group_id=:2'

Line 1648: Value for the GL_PERIOD_NUM attribute (in fem_cal_periods_attr)

1644: DIMENSION_GROUP_ID (in fem_cal_periods_b) matches the
1645: DIMENSION_GROUP_ID from fem_dimension_grps_b where
1646: the DIMENSION_GROUP_DISPLAY_CODE = p_dim grp_dc
1647:
1648: Value for the GL_PERIOD_NUM attribute (in fem_cal_periods_attr)
1649: matches the value from p_cal_per_num
1650:
1651: Value for the ACCOUNTING_YEAR attribute (in fem_Cal_periods_attr)
1652: matches value in p_fiscal_year.

Line 1651: Value for the ACCOUNTING_YEAR attribute (in fem_Cal_periods_attr)

1647:
1648: Value for the GL_PERIOD_NUM attribute (in fem_cal_periods_attr)
1649: matches the value from p_cal_per_num
1650:
1651: Value for the ACCOUNTING_YEAR attribute (in fem_Cal_periods_attr)
1652: matches value in p_fiscal_year.
1653:
1654: HISTORY
1655: 04-AUG-06 rflippo Bug 5060702 Split single sql statement into individual

Line 1751: fem_cal_periods_attr N,

1747:
1748: SELECT B.cal_period_id
1749: INTO v_cal_period_id
1750: FROM fem_cal_periods_b B,
1751: fem_cal_periods_attr N,
1752: fem_cal_periods_attr D,
1753: fem_dimension_grps_b G
1754: WHERE N.attribute_id = v_periodnum_attr_id
1755: AND N.version_id = v_periodnum_vers_id

Line 1752: fem_cal_periods_attr D,

1748: SELECT B.cal_period_id
1749: INTO v_cal_period_id
1750: FROM fem_cal_periods_b B,
1751: fem_cal_periods_attr N,
1752: fem_cal_periods_attr D,
1753: fem_dimension_grps_b G
1754: WHERE N.attribute_id = v_periodnum_attr_id
1755: AND N.version_id = v_periodnum_vers_id
1756: AND N.cal_period_id = B.cal_period_id

Line 1787: Value for the GL_PERIOD_NUM attribute (in fem_cal_periods_attr)

1783: DIMENSION_GROUP_ID (in fem_cal_periods_b) matches the
1784: DIMENSION_GROUP_ID from fem_dimension_grps_b where
1785: the DIMENSION_GROUP_DISPLAY_CODE = p_dim grp_dc
1786:
1787: Value for the GL_PERIOD_NUM attribute (in fem_cal_periods_attr)
1788: matches the value from p_cal_per_num
1789:
1790: Value for the CAL_PERIOD_END_DATE attribute (in
1791: fem_Cal_periods_attr) matches value in p_cal_per_end_date.

Line 1791: fem_Cal_periods_attr) matches value in p_cal_per_end_date.

1787: Value for the GL_PERIOD_NUM attribute (in fem_cal_periods_attr)
1788: matches the value from p_cal_per_num
1789:
1790: Value for the CAL_PERIOD_END_DATE attribute (in
1791: fem_Cal_periods_attr) matches value in p_cal_per_end_date.
1792:
1793: 04-AUG-06 rflippo Bug 5060702 Split single sql statement into individual
1794: statements to avoid cartesian join
1795: *************************************************************************/

Line 1890: fem_cal_periods_attr N,

1886:
1887: SELECT B.cal_period_id
1888: INTO v_cal_period_id
1889: FROM fem_cal_periods_b B,
1890: fem_cal_periods_attr N,
1891: fem_cal_periods_attr D,
1892: fem_dimension_grps_b G
1893: WHERE N.attribute_id = v_periodnum_attr_id
1894: AND N.version_id = v_periodnum_vers_id

Line 1891: fem_cal_periods_attr D,

1887: SELECT B.cal_period_id
1888: INTO v_cal_period_id
1889: FROM fem_cal_periods_b B,
1890: fem_cal_periods_attr N,
1891: fem_cal_periods_attr D,
1892: fem_dimension_grps_b G
1893: WHERE N.attribute_id = v_periodnum_attr_id
1894: AND N.version_id = v_periodnum_vers_id
1895: AND N.cal_period_id = B.cal_period_id