APPS.PSB_VALIDATE_ACCT_PVT dependencies on PSB_BUDGET_ACCOUNTS

Line 331: (select 1 from PSB_BUDGET_ACCOUNTS

327: -- This is valid only if p_return_code is 0
328:
329: l_cc_in_ba_flag := FND_API.G_FALSE;
330: FOR ba_rec IN
331: (select 1 from PSB_BUDGET_ACCOUNTS
332: where code_combination_id = p_code_combination_id)
333: LOOP
334: l_cc_in_ba_flag := FND_API.G_TRUE;
335: EXIT;

Line 351: psb_budget_accounts ba

347: FOR ba_rec IN
348: (
349: select sr.budget_group_id
350: from psb_set_relations_v sr,
351: psb_budget_accounts ba
352: where sr.budget_group_id in
353: (select budget_group_id
354: from PSB_BUDGET_GROUPS
355: where budget_group_type = 'R'

Line 403: FROM PSB_BUDGET_ACCOUNTS

399: /*For Bug No : 2026323 Start*/
400: l_ccid_exists BOOLEAN;
401: CURSOR c_budget_account(aps_id NUMBER, ccid NUMBER) IS
402: SELECT 1
403: FROM PSB_BUDGET_ACCOUNTS
404: WHERE account_position_set_id = aps_id
405: AND code_combination_id = ccid;
406: /*For Bug No : 2026323 End*/
407:

Line 506: INSERT INTO psb_budget_accounts(

502:
503: -- create record in budget accounts table only if flag is on
504: IF p_create_budget_account = FND_API.G_TRUE then
505:
506: INSERT INTO psb_budget_accounts(
507: account_position_set_id,
508: set_of_books_id,
509: code_combination_id,
510: last_update_date,

Line 564: INSERT INTO psb_budget_accounts(

560:
561: -- create record in budget accounts table only if flag is on
562: IF p_create_budget_account = FND_API.G_TRUE then
563:
564: INSERT INTO psb_budget_accounts(
565: account_position_set_id,
566: set_of_books_id,
567: code_combination_id,
568: last_update_date,

Line 626: INSERT INTO psb_budget_accounts(

622:
623: -- create record in budget accounts table only if flag is on
624: IF p_create_budget_account = FND_API.G_TRUE then
625:
626: INSERT INTO psb_budget_accounts(
627: account_position_set_id,
628: set_of_books_id,
629: code_combination_id,
630: last_update_date,