APPS.PSB_BUDGET_ACCOUNT_PVT dependencies on PSB_BUDGET_ACCOUNTS

Line 337: -- If Yes, you need to rebuild the psb_budget_accounts table for this

333: WHERE account_position_set_id = p_account_set_id;
334:
335: --
336: -- Check whether the account_set has been modified since last maintenance.
337: -- If Yes, you need to rebuild the psb_budget_accounts table for this
338: -- account set.
339: --
340: IF l_last_update_date > l_last_maintained_date THEN
341:

Line 342: -- Delete from psb_budget_accounts

338: -- account set.
339: --
340: IF l_last_update_date > l_last_maintained_date THEN
341:
342: -- Delete from psb_budget_accounts
343: DELETE psb_budget_accounts
344: WHERE account_position_set_id = p_account_set_id ;
345:
346: -- Reset g_max_code_combination_id as you have to rebuild.

Line 343: DELETE psb_budget_accounts

339: --
340: IF l_last_update_date > l_last_maintained_date THEN
341:
342: -- Delete from psb_budget_accounts
343: DELETE psb_budget_accounts
344: WHERE account_position_set_id = p_account_set_id ;
345:
346: -- Reset g_max_code_combination_id as you have to rebuild.
347: g_max_code_combination_id := 0 ;

Line 370: -- line_sequence_id and put them im psb_budget_accounts table.

366: )
367: LOOP
368: --
369: -- Get the account codes falling in each range represented by
370: -- line_sequence_id and put them im psb_budget_accounts table.
371: --
372: IF NOT Make_Account_Assignments
373: (
374: l_line_rec.line_sequence_id ,

Line 491: -- in psb_budget_accounts.

487: | FUNCTION Make_Account_Assignments (Private) |
488: +===========================================================================*/
489: --
490: -- Private function to get active account codes for a range and put them
491: -- in psb_budget_accounts.
492: --
493:
494: FUNCTION Make_Account_Assignments
495: (

Line 521: l_sql_insert := ' INSERT INTO psb_budget_accounts(' ||

517:
518: --
519: -- Insert the account codes falling in the range.
520: --
521: l_sql_insert := ' INSERT INTO psb_budget_accounts(' ||
522: ' account_position_set_id,' ||
523: ' set_of_books_id,' ||
524: ' code_combination_id,' ||
525: ' last_update_date,' ||

Line 544: l_sql_delete := ' DELETE psb_budget_accounts' ||

540: pd('Building Delete statement');
541: --
542: -- Delete the account codes falling in the range.
543: --
544: l_sql_delete := ' DELETE psb_budget_accounts' ||
545: ' WHERE account_position_set_id =' ||
546: ' :account_set_id' ||
547: ' AND code_combination_id IN' ||
548: ' ( SELECT code_combination_id';

Line 591: ' FROM psb_budget_accounts' ||

587: l_sql_tmp ||
588: ' AND NOT EXISTS ' ||
589: ' ( SELECT account_position_set_id,' ||
590: ' code_combination_id' ||
591: ' FROM psb_budget_accounts' ||
592: ' WHERE account_position_set_id = :account_set_id' ||
593: ' AND code_combination_id = glcc.code_combination_id )' ;
594:
595: -- Parsing the statement.