DBA Data[Home] [Help]

APPS.PAY_CALENDARS_PKG dependencies on PER_BUDGETS

Line 43: FROM per_budgets pb

39: -- Called by Delete_Row
40: --
41: CURSOR c_budgets IS
42: SELECT NULL
43: FROM per_budgets pb
44: WHERE pb.period_set_name = X_Period_Set_Name
45: AND pb.budget_type_code = 'OTA_BUDGET';
46: --
47: CURSOR c_pqh_budgets IS

Line 477: -- if per_budgets record of 'OTA_BUDGET' budget_type_code exists

473: X_Period_Set_Name VARCHAR2) IS
474: BEGIN
475: --
476: -- New check procedure added to prevent delete of calendar record
477: -- if per_budgets record of 'OTA_BUDGET' budget_type_code exists
478: chk_budget_exists(X_Period_Set_Name);
479:
480: -- Remove all the time periods for the calendar NB. makes sure that the
481: -- calendar has not been used for budgetting.