APPS.PSB_WS_ACCT1 dependencies on PSB_SET_RELATIONS

Line 2637: from PSB_SET_RELATIONS a,

2633: --
2634: cursor c_Budget_Group is
2635: select a.budget_group_id,
2636: b.num_proposed_years
2637: from PSB_SET_RELATIONS a,
2638: PSB_BUDGET_GROUPS b,
2639: PSB_BUDGET_ACCOUNTS c
2640: where a.budget_group_id = b.budget_group_id
2641: and (((b.effective_start_date <= l_end_date)

Line 5703: psb_set_relations_v e,

5699:
5700: cursor c_Account_types is
5701: select distinct f.account_type
5702: from psb_budget_accounts d,
5703: psb_set_relations_v e,
5704: psb_ws_account_lines f,
5705: psb_ws_lines g
5706: where d.account_position_set_id = e.account_position_set_id
5707: and e.account_or_position_type = 'A'

Line 5801: psb_set_relations e

5797: CURSOR l_Accounts_csr
5798: IS
5799: SELECT d.code_combination_id, e.account_position_set_id
5800: FROM psb_budget_accounts d,
5801: psb_set_relations e
5802: WHERE d.account_position_set_id = e.account_position_set_id
5803: AND e.constraint_id = p_constraint_id
5804: AND EXISTS
5805: (SELECT 1

Line 5807: psb_set_relations b

5803: AND e.constraint_id = p_constraint_id
5804: AND EXISTS
5805: (SELECT 1
5806: FROM psb_budget_accounts a,
5807: psb_set_relations b
5808: WHERE a.account_position_set_id = b.account_position_set_id
5809: AND b.budget_group_id = l_budget_group_id
5810: AND a.code_combination_id = d.code_combination_id);
5811:

Line 5816: psb_set_relations e

5812: CURSOR l_Accounts_global_csr
5813: IS
5814: SELECT d.code_combination_id, e.account_position_set_id
5815: FROM psb_budget_accounts d,
5816: psb_set_relations e
5817: WHERE d.account_position_set_id = e.account_position_set_id
5818: --AND e.account_or_position_type = 'A'
5819: AND e.constraint_id = p_constraint_id;
5820: /* Bug 3608191 End */

Line 5983: psb_set_relations e

5979: /* Bug 2321186 Start */
5980: CURSOR c_Accounts IS
5981: SELECT d.code_combination_id
5982: FROM psb_budget_accounts d,
5983: psb_set_relations e
5984: WHERE d.account_position_set_id = e.account_position_set_id
5985: AND e.constraint_id = p_constraint_id;
5986:
5987: l_sum_amount NUMBER := 0;

Line 6847: PSB_SET_RELATIONS_V b

6843:
6844: cursor c_CCID is
6845: select a.code_combination_id ccid
6846: from PSB_BUDGET_ACCOUNTS a,
6847: PSB_SET_RELATIONS_V b
6848: where exists
6849: (select 1
6850: from PSB_BUDGET_ACCOUNTS c,
6851: PSB_SET_RELATIONS_V d

Line 6851: PSB_SET_RELATIONS_V d

6847: PSB_SET_RELATIONS_V b
6848: where exists
6849: (select 1
6850: from PSB_BUDGET_ACCOUNTS c,
6851: PSB_SET_RELATIONS_V d
6852: where c.account_position_set_id = d.account_position_set_id
6853: and c.code_combination_id = a.code_combination_id
6854: and d.account_or_position_type = 'A'
6855: and exists