APPS.PQH_COMMITMENT_PKG dependencies on PAY_CALENDARS

Line 185: from pay_calendars pc

181: -- Obtain the frequency of the time periods for a calendar
182: --
183: Cursor csr_bdgt_cal_freq is
184: Select pc.actual_period_type
185: from pay_calendars pc
186: Where pc.period_set_name = p_period_set_name;
187: --
188: l_proc varchar2(72) := g_package || 'Validate_budget';
189: l_budgeted_entity_cd varchar2(30) := null;

Line 2853: l_budget_cal_freq pay_calendars.actual_period_type%type;

2849: --
2850: l_budget_id pqh_budgets.budget_id%type := NULL;
2851: l_budget_name pqh_budgets.budget_name%type := NULL;
2852: l_period_set_name pqh_budgets.period_set_name%type := NULL;
2853: l_budget_cal_freq pay_calendars.actual_period_type%type;
2854: l_budget_start_date date;
2855: l_budget_end_date date;
2856: l_cmmtmnt_start_dt date;
2857: l_cmmtmnt_end_dt date;

Line 3697: from pay_calendars pc

3693: -- Obtain the frequency of the time periods for a calendar
3694: --
3695: Cursor csr_bdgt_cal_freq(p_period_set_name varchar2) is
3696: Select pc.actual_period_type
3697: from pay_calendars pc
3698: Where pc.period_set_name = p_period_set_name;
3699: --
3700: -- Get Position Id from the Current Assignment
3701: --

Line 3763: l_budget_cal_freq pay_calendars.actual_period_type%type;

3759: l_dflt_elmnt_frequency varchar2(30);
3760: l_budget_id pqh_budgets.budget_id%type := NULL;
3761: l_budget_name pqh_budgets.budget_name%type := NULL;
3762: l_period_set_name pqh_budgets.period_set_name%type := NULL;
3763: l_budget_cal_freq pay_calendars.actual_period_type%type;
3764: l_budget_start_date date;
3765: l_budget_end_date date;
3766: l_cmmtmnt_start_dt date;
3767: l_entity_id Number;