APPS.PSB_CREATE_BR_PVT dependencies on PSB_BUDGET_GROUPS

Line 429: l_main_budget_group_name psb_budget_groups.name%TYPE ;

425: l_msg_data VARCHAR2(2000) ;
426: --
427: l_revision_justification psb_budget_revisions.justification%TYPE ;
428: l_main_budget_group_id psb_budget_revisions.budget_group_id%TYPE ;
429: l_main_budget_group_name psb_budget_groups.name%TYPE ;
430: l_new_budget_revision_id psb_budget_revisions.budget_revision_id%TYPE ;
431: l_global_budget_revision_id psb_budget_revisions.budget_revision_id%TYPE ;
432: --
433: l_tmp_char VARCHAR2(1) ;

Line 477: FROM psb_budget_groups

473: --
474: -- Validating p_budget_group_id.
475: --
476: SELECT '1' INTO l_tmp_char
477: FROM psb_budget_groups
478: WHERE budget_group_id = p_budget_group_id ;
479:
480: --
481: -- Finding the worksheet information.

Line 503: FROM psb_budget_groups

499: --
500: -- Finding the main budget group name.
501: --
502: SELECT name INTO l_main_budget_group_name
503: FROM psb_budget_groups
504: WHERE budget_group_id = l_main_budget_group_id;
505:
506: --
507: -- Get translated messages for the new budget revision.

Line 626: FROM psb_budget_groups

622: AND lines.budget_revision_acct_line_id =
623: acct.budget_revision_acct_line_id
624: AND acct.budget_group_id in
625: ( SELECT budget_group_id
626: FROM psb_budget_groups
627: WHERE budget_group_type = 'R'
628: AND effective_start_date <= sysdate
629: AND ((effective_end_date IS NULL)
630: OR

Line 693: FROM psb_budget_groups bg

689: = pos.budget_revision_pos_line_id
690: AND pos.budget_group_id in
691: (
692: SELECT bg.budget_group_id
693: FROM psb_budget_groups bg
694: WHERE budget_group_type = 'R'
695: AND effective_start_date <= sysdate
696: AND ((effective_end_date IS NULL)
697: OR

Line 1056: psb_budget_groups bg

1052: l_global_budget_revision_id,
1053: l_global_budget_revision,
1054: l_parent_budget_group_id
1055: FROM psb_budget_revisions br,
1056: psb_budget_groups bg
1057: WHERE br.budget_revision_id = p_budget_revision_id
1058: AND br.budget_group_id = bg.budget_group_id ;
1059:
1060: IF (l_global_budget_revision = 'Y') OR

Line 1387: FROM psb_budget_groups

1383: --
1384: FOR l_budget_group_rec IN
1385: (
1386: SELECT budget_group_id
1387: FROM psb_budget_groups
1388: WHERE budget_group_type = 'R'
1389: AND effective_start_date <= sysdate
1390: AND ((effective_end_date IS NULL)
1391: OR

Line 1646: FROM psb_budget_groups

1642: =
1643: acct.budget_revision_acct_line_id
1644: AND acct.budget_group_id in
1645: ( SELECT budget_group_id
1646: FROM psb_budget_groups
1647: WHERE budget_group_type = 'R'
1648: AND effective_start_date <= sysdate
1649: AND ((effective_end_date IS NULL)
1650: OR

Line 1719: FROM psb_budget_groups bg

1715: = pos.budget_revision_pos_line_id
1716: AND pos.budget_group_id in
1717: (
1718: SELECT bg.budget_group_id
1719: FROM psb_budget_groups bg
1720: WHERE bg.budget_group_type = 'R'
1721: AND effective_start_date <= sysdate
1722: AND ((effective_end_date IS NULL)
1723: OR