APPS.PQH_BUDGETED_SALARY_PKG dependencies on PER_TIME_PERIODS

Line 37: per_time_periods stp,

33: pqh_budgets bud,
34: pqh_budget_versions bver,
35: pqh_budget_details bdet,
36: pqh_budget_periods bper,
37: per_time_periods stp,
38: per_time_periods etp,
39: pqh_budget_sets bsets,
40: pqh_budget_elements bele,
41: pqh_bdgt_cmmtmnt_elmnts bcl

Line 38: per_time_periods etp,

34: pqh_budget_versions bver,
35: pqh_budget_details bdet,
36: pqh_budget_periods bper,
37: per_time_periods stp,
38: per_time_periods etp,
39: pqh_budget_sets bsets,
40: pqh_budget_elements bele,
41: pqh_bdgt_cmmtmnt_elmnts bcl
42: where nvl(bud.position_control_flag,'X') = 'Y'

Line 153: per_time_periods stp,

149: pqh_budgets bud,
150: pqh_budget_versions bver,
151: pqh_budget_details bdet,
152: pqh_budget_periods bper,
153: per_time_periods stp,
154: per_time_periods etp
155: where nvl(bud.position_control_flag,'X') = 'Y'
156: and bud.budgeted_entity_cd = p_budget_entity
157: and bud.business_group_id = p_business_group_id

Line 154: per_time_periods etp

150: pqh_budget_versions bver,
151: pqh_budget_details bdet,
152: pqh_budget_periods bper,
153: per_time_periods stp,
154: per_time_periods etp
155: where nvl(bud.position_control_flag,'X') = 'Y'
156: and bud.budgeted_entity_cd = p_budget_entity
157: and bud.business_group_id = p_business_group_id
158: and ((p_start_date <= bud.budget_start_date

Line 245: per_time_periods

241: cursor no_periods_tp(p_period_set_name varchar2, p_start_date date, p_end_date date) is
242: select
243: count(*)
244: from
245: per_time_periods
246: where
247: period_set_name = p_period_set_name
248: and p_start_date <= start_date
249: and p_end_date >= end_date;

Line 259: per_time_periods

255: select
256: start_date,
257: end_date
258: from
259: per_time_periods
260: where
261: p_period_set_name = period_set_name
262: and ((p_start_date <= start_date
263: and p_end_date >= end_date