APPS.PSB_WS_ACCT2 dependencies on PSB_BUDGET_ACCOUNTS

Line 895: --FROM PSB_BUDGET_ACCOUNTS a, GL_CODE_COMBINATIONS b

891:
892: -- for bug 4256345
893: --CURSOR c_ccids (AccSetID NUMBER) is
894: --SELECT a.code_combination_id, b.start_date_active, b.end_date_active
895: --FROM PSB_BUDGET_ACCOUNTS a, GL_CODE_COMBINATIONS b
896: --WHERE a.account_position_set_id = AccSetID
897: /* Bug 3692601 Start */
898: --AND b.detail_budgeting_allowed_flag = 'Y'
899: /* Bug 3692601 End */

Line 911: FROM psb_budget_accounts

907:
908: CURSOR l_ccid_csr (AcctsetId NUMBER)
909: IS
910: SELECT code_combination_id
911: FROM psb_budget_accounts
912: WHERE account_position_set_id = AcctsetId;
913:
914: lt_start_date_active DATE;
915: lt_end_date_active DATE;

Line 2499: FROM psb_budget_accounts a,

2495: --
2496: CURSOR c_ccids ( c_account_set_id NUMBER)
2497: IS
2498: SELECT a.code_combination_id, b.start_date_active, b.end_date_active
2499: FROM psb_budget_accounts a,
2500: gl_code_combinations b
2501: WHERE a.account_position_set_id = c_account_set_id
2502: /* Bug 3692601 Start */
2503: AND b.detail_budgeting_allowed_flag = 'Y'

Line 2515: FROM psb_budget_accounts

2511: SELECT '1'
2512: FROM dual
2513: WHERE EXISTS
2514: ( SELECT 1
2515: FROM psb_budget_accounts
2516: WHERE code_combination_id = c_code_combination_id
2517: AND account_position_set_id = l_ps_set_id ) ;
2518: --
2519: BEGIN

Line 3994: PSB_BUDGET_ACCOUNTS c

3990: where entity_id = p_parameter_id
3991: and exists
3992: (select 1
3993: from PSB_SET_RELATIONS b,
3994: PSB_BUDGET_ACCOUNTS c
3995: where b.account_position_set_id = c.account_position_set_id
3996: and b.parameter_id = p_parameter_id
3997: and c.code_combination_id = p_ccid)
3998: and a.entity_subtype = 'ACCOUNT'

Line 4451: PSB_BUDGET_ACCOUNTS c

4447: from PSB_PARAMETER_ASSIGNMENTS_V a
4448: where exists
4449: (select 1
4450: from PSB_SET_RELATIONS b,
4451: PSB_BUDGET_ACCOUNTS c
4452: where b.account_position_set_id = c.account_position_set_id
4453: and b.parameter_id = a.parameter_id
4454: and c.code_combination_id = p_ccid
4455: )

Line 5729: PSB_BUDGET_ACCOUNTS c

5725: and pe.entity_id = pea.entity_id
5726: and exists
5727: (select 1
5728: from PSB_SET_RELATIONS b,
5729: PSB_BUDGET_ACCOUNTS c
5730: where b.account_position_set_id = c.account_position_set_id
5731: and b.allocation_rule_id = pea.entity_id
5732: and c.code_combination_id = p_ccid)
5733: and pe.entity_subtype = 'ACCOUNT'

Line 8213: FROM psb_budget_accounts a,

8209:
8210: CURSOR l_ccid_csr
8211: IS
8212: SELECT code_combination_id
8213: FROM psb_budget_accounts a,
8214: psb_set_relations r,
8215: psb_gl_budgets b,
8216: psb_gl_budget_sets c
8217: WHERE c.gl_budget_set_id = p_gl_budget_set_id