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.GMS_BUDGET_PUB dependencies on PA_BUDGET_PERIODS_V

Line 1101: from pa_budget_periods_v

1097: -- Bug 1555396 : x_start_date and x_end_date should be not null
1098: if x_period_type in ('G','P') AND x_start_date IS NOT NULL AND x_end_date IS NOT NULL then
1099: select period_name
1100: into x_period_name
1101: from pa_budget_periods_v
1102: where period_start_date = x_start_date
1103: and period_end_date = x_end_date
1104: and period_type_code = x_period_type;
1105: end if;

Line 1662: FROM pa_budget_periods_v

1658: (p_period_name VARCHAR2
1659: ,p_period_type_code VARCHAR2 )
1660: IS
1661: SELECT period_name
1662: FROM pa_budget_periods_v
1663: WHERE period_name = p_period_name
1664: AND period_type_code = p_period_type_code;
1665:
1666:

Line 5590: FROM pa_budget_periods_v

5586: (p_period_name VARCHAR2
5587: ,p_time_phased_type_code VARCHAR2 )
5588: IS
5589: SELECT trunc(period_start_date), trunc(period_end_date) -- added end_date which is required in validate_budget()
5590: FROM pa_budget_periods_v
5591: WHERE period_name = p_period_name
5592: AND period_type_code = p_time_phased_type_code;
5593:
5594: --needed to validate to given start_date

Line 5601: FROM pa_budget_periods_v

5597: (p_start_date DATE
5598: ,p_time_phased_type_code VARCHAR2 )
5599: IS
5600: SELECT 1
5601: FROM pa_budget_periods_v
5602: WHERE trunc(period_start_date) = trunc(p_start_date)
5603: AND period_type_code = p_time_phased_type_code;
5604:
5605: --needed to lock the budget line row

Line 6310: FROM pa_budget_periods_v

6306: (p_period_name VARCHAR2
6307: ,p_period_type_code VARCHAR2 )
6308: IS
6309: SELECT period_name
6310: FROM pa_budget_periods_v
6311: WHERE period_name = p_period_name
6312: AND period_type_code = p_period_type_code;
6313:
6314: -- the uncategorized resource list

Line 6976: FROM pa_budget_periods_v

6972: (p_period_name VARCHAR2
6973: ,p_period_type_code VARCHAR2 )
6974: IS
6975: SELECT trunc(period_start_date), trunc(period_end_date)
6976: FROM pa_budget_periods_v
6977: WHERE period_name = p_period_name
6978: AND period_type_code = p_period_type_code;
6979:
6980: