APPS.PSB_WS_POS1 dependencies on PSB_BUDGET_GROUPS

Line 47: from PSB_BUDGET_GROUPS_V

43: and position_line_id = PosLine;
44:
45: cursor c_BG (BudGrp NUMBER) is
46: select nvl(business_group_id, root_business_group_id) business_group_id
47: from PSB_BUDGET_GROUPS_V
48: where budget_group_id = BudGrp;
49:
50: cursor c_FTESeq is
51: select psb_ws_fte_lines_s.nextval FteLineID

Line 533: from PSB_BUDGET_GROUPS

529: l_return_status VARCHAR2(1) := FND_API.G_FALSE;
530:
531: cursor c_Allowed is
532: select 'Valid'
533: from PSB_BUDGET_GROUPS
534: where budget_group_type = 'R'
535: and effective_start_date <= PSB_WS_ACCT1.g_startdate_pp
536: and (effective_end_date is null
537: or effective_end_date >= PSB_WS_ACCT1.g_enddate_cy)

Line 1118: PSB_BUDGET_GROUPS b,

1114: cursor c_Budget_Group (CCID NUMBER) is
1115: select a.budget_group_id,
1116: b.num_proposed_years
1117: from PSB_SET_RELATIONS a,
1118: PSB_BUDGET_GROUPS b,
1119: PSB_BUDGET_ACCOUNTS c
1120: where a.budget_group_id = b.budget_group_id
1121: and b.effective_start_date <= PSB_WS_ACCT1.g_startdate_pp
1122: and (b.effective_end_date is null

Line 3109: FROM PSB_BUDGET_GROUPS_V

3105:
3106: CURSOR c_bg IS
3107: SELECT nvl(root_budget_group_id, budget_group_id) root_budget_group_id,
3108: nvl(set_of_books_id, root_set_of_books_id) set_of_books_id
3109: FROM PSB_BUDGET_GROUPS_V
3110: WHERE budget_group_id = l_budget_group_id;
3111:
3112: CURSOR c_sob IS
3113: SELECT chart_of_accounts_id