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.PQH_BGT_BUS dependencies on PER_TIME_PERIODS

Line 1017: FROM per_time_periods

1013: -- cursor to check if atleast one period exists
1014:
1015: CURSOR cnt_periods IS
1016: SELECT COUNT(*)
1017: FROM per_time_periods
1018: WHERE period_set_name = p_period_set_name
1019: AND start_date BETWEEN p_budget_start_date AND p_budget_end_date
1020: AND end_date BETWEEN p_budget_start_date AND p_budget_end_date ;
1021:

Line 1022: -- cursor to check start_date in per_time_periods table

1018: WHERE period_set_name = p_period_set_name
1019: AND start_date BETWEEN p_budget_start_date AND p_budget_end_date
1020: AND end_date BETWEEN p_budget_start_date AND p_budget_end_date ;
1021:
1022: -- cursor to check start_date in per_time_periods table
1023: CURSOR per_cal_start_dt_cur IS
1024: SELECT MIN(start_date)
1025: FROM per_time_periods
1026: WHERE period_set_name = p_period_set_name;

Line 1025: FROM per_time_periods

1021:
1022: -- cursor to check start_date in per_time_periods table
1023: CURSOR per_cal_start_dt_cur IS
1024: SELECT MIN(start_date)
1025: FROM per_time_periods
1026: WHERE period_set_name = p_period_set_name;
1027:
1028: -- cursor to check in budget tables
1029: CURSOR budget_date_cur IS

Line 1031: FROM per_time_periods tp,

1027:
1028: -- cursor to check in budget tables
1029: CURSOR budget_date_cur IS
1030: SELECT MIN(start_date)
1031: FROM per_time_periods tp,
1032: pqh_budget_periods bpr,
1033: pqh_budget_details bdt,
1034: pqh_budget_versions bvr
1035: WHERE time_period_id = bpr.start_time_period_id

Line 1043: FROM per_time_periods tp,

1039:
1040: -- cursor to check in worksheet tables
1041: CURSOR wks_date_cur IS
1042: SELECT MIN(start_date)
1043: FROM per_time_periods tp,
1044: pqh_worksheet_periods bpr,
1045: pqh_worksheet_details bdt,
1046: pqh_worksheets bvr
1047: WHERE time_period_id = bpr.start_time_period_id

Line 1112: check if the budget_start_dt is >= the minimum date (start_date) in per_time_periods

1108: end if;
1109: --
1110: --
1111: /*
1112: check if the budget_start_dt is >= the minimum date (start_date) in per_time_periods
1113: where period_set_name = period_set_name of the current budget
1114: */
1115: OPEN per_cal_start_dt_cur;
1116: FETCH per_cal_start_dt_cur INTO l_min_cal_dt;

Line 1194: FROM per_time_periods

1190: -- cursor to check if atleast one period exists
1191:
1192: CURSOR cnt_periods IS
1193: SELECT COUNT(*)
1194: FROM per_time_periods
1195: WHERE period_set_name = p_period_set_name
1196: AND start_date BETWEEN p_budget_start_date AND p_budget_end_date
1197: AND end_date BETWEEN p_budget_start_date AND p_budget_end_date ;
1198: --

Line 1200: -- cursor to check end_date in per_time_periods table

1196: AND start_date BETWEEN p_budget_start_date AND p_budget_end_date
1197: AND end_date BETWEEN p_budget_start_date AND p_budget_end_date ;
1198: --
1199:
1200: -- cursor to check end_date in per_time_periods table
1201: CURSOR per_cal_end_dt_cur IS
1202: SELECT MAX(end_date)
1203: FROM per_time_periods
1204: WHERE period_set_name = p_period_set_name;

Line 1203: FROM per_time_periods

1199:
1200: -- cursor to check end_date in per_time_periods table
1201: CURSOR per_cal_end_dt_cur IS
1202: SELECT MAX(end_date)
1203: FROM per_time_periods
1204: WHERE period_set_name = p_period_set_name;
1205: --
1206: -- cursor to check in budget tables
1207: CURSOR budget_date_cur IS

Line 1209: FROM per_time_periods tp,

1205: --
1206: -- cursor to check in budget tables
1207: CURSOR budget_date_cur IS
1208: SELECT MIN(start_date)
1209: FROM per_time_periods tp,
1210: pqh_budget_periods bpr,
1211: pqh_budget_details bdt,
1212: pqh_budget_versions bvr
1213: WHERE time_period_id = bpr.start_time_period_id

Line 1221: FROM per_time_periods tp,

1217:
1218: -- cursor to check in worksheet tables
1219: CURSOR wks_date_cur IS
1220: SELECT MIN(start_date)
1221: FROM per_time_periods tp,
1222: pqh_worksheet_periods bpr,
1223: pqh_worksheet_details bdt,
1224: pqh_worksheets bvr
1225: WHERE time_period_id = bpr.start_time_period_id

Line 1289: check if the budget_end_dt is <= the maximum date (end_date) in per_time_periods

1285: end if;
1286: --
1287: --
1288: /*
1289: check if the budget_end_dt is <= the maximum date (end_date) in per_time_periods
1290: where period_set_name = period_set_name of the current budget
1291: */
1292: OPEN per_cal_end_dt_cur;
1293: FETCH per_cal_end_dt_cur INTO l_max_cal_dt;