APPS.PSB_POSITION_CONTROL_PVT dependencies on PQH_PSB_BUDGETS

Line 8051: from pqh_psb_budgets pb, pay_calendars pc

8047: l_period_type_mismatch BOOLEAN := FALSE;
8048:
8049: cursor c_hrms_period_type is
8050: select pc.proc_period_type
8051: from pqh_psb_budgets pb, pay_calendars pc
8052: where pb.budget_id = p_hr_budget_id
8053: and pc.period_set_name = pb.period_set_name;
8054:
8055: cursor c_psb_period_type is

Line 10202: from per_time_periods pt, pqh_psb_budgets pb

10198: and end_time_period_id = end_period_id;
10199:
10200: cursor c_time_periods (startdate DATE) is
10201: select pt.time_period_id, pt.start_date, pt.end_date
10202: from per_time_periods pt, pqh_psb_budgets pb
10203: where pb.budget_id = p_hr_budget_id
10204: and pt.period_set_name = pb.period_set_name
10205: and startdate between pt.start_date and pt.end_date;
10206:

Line 10209: from per_time_periods pt, pqh_psb_budgets pb

10205: and startdate between pt.start_date and pt.end_date;
10206:
10207: cursor c_time_periods_br (startdate DATE, enddate DATE) is
10208: select pt.time_period_id, pt.start_date, pt.end_date
10209: from per_time_periods pt, pqh_psb_budgets pb
10210: where pb.budget_id = p_hr_budget_id
10211: and pt.period_set_name = pb.period_set_name
10212: and ((pt.start_date between startdate and enddate)
10213: or (pt.end_date between startdate and enddate)

Line 11585: from pqh_psb_budgets

11581:
11582: cursor c_pqh_budget is
11583: select budget_name, currency_code, business_group_id, budget_unit1_id, budget_unit2_id,
11584: budget_unit3_id, budget_unit1_aggregate, budget_unit2_aggregate, budget_unit3_aggregate
11585: from pqh_psb_budgets
11586: where budget_id = p_hr_budget_id;
11587:
11588: /*For Bug No : 2292003 Start*/
11589: --changed the view_name from per_business_groups to