eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSB_WS_OPS_PVT dependencies on PSB_BUDGET_GROUPS

Line 526: l_main_budget_group_name psb_budget_groups.name%TYPE ;

522: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;
523: l_worksheet_description psb_worksheets.description%TYPE ;
524: l_main_worksheet_name psb_worksheets.name%TYPE ;
525: l_main_budget_group_id psb_worksheets.budget_group_id%TYPE ;
526: l_main_budget_group_name psb_budget_groups.name%TYPE ;
527: l_main_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;
528: l_new_worksheet_id psb_worksheets.worksheet_id%TYPE ;
529: l_global_worksheet_id psb_worksheets.worksheet_id%TYPE ;
530: l_service_package_count NUMBER ;

Line 592: FROM psb_budget_groups

588: --
589: -- Validating p_budget_group_id.
590: --
591: SELECT '1' INTO l_tmp_char
592: FROM psb_budget_groups
593: WHERE budget_group_id = p_budget_group_id ;
594:
595: --
596: -- Validating p_account_position_set_tbl table.

Line 633: FROM psb_budget_groups

629: --
630: -- Finding the main budget group name.
631: --
632: SELECT name INTO l_main_budget_group_name
633: FROM psb_budget_groups
634: WHERE budget_group_id = l_main_budget_group_id ;
635:
636: --
637: -- Get translated messages for the new worksheet.

Line 1061: l_main_budget_group_name psb_budget_groups.name%TYPE ;

1057: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;
1058: l_worksheet_description psb_worksheets.description%TYPE ;
1059: l_main_worksheet_name psb_worksheets.name%TYPE ;
1060: l_main_budget_group_id psb_worksheets.budget_group_id%TYPE ;
1061: l_main_budget_group_name psb_budget_groups.name%TYPE ;
1062: l_main_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;
1063: l_new_worksheet_id psb_worksheets.worksheet_id%TYPE ;
1064: l_global_worksheet_id psb_worksheets.worksheet_id%TYPE ;
1065: --

Line 1099: FROM psb_budget_groups

1095: --
1096: -- Validating p_budget_group_id.
1097: --
1098: SELECT '1' INTO l_tmp_char
1099: FROM psb_budget_groups
1100: WHERE budget_group_id = p_budget_group_id ;
1101:
1102: --
1103: -- Finding the worksheet information.

Line 1128: FROM psb_budget_groups

1124: --
1125: -- Finding the main budget group name.
1126: --
1127: SELECT name INTO l_main_budget_group_name
1128: FROM psb_budget_groups
1129: WHERE budget_group_id = l_main_budget_group_id ;
1130:
1131: --
1132: -- Get translated messages for the new worksheet.

Line 1249: FROM psb_budget_groups

1245: /*For Bug No : 2236283 Start*/
1246: /*
1247: AND accts.budget_group_id IN
1248: ( SELECT budget_group_id
1249: FROM psb_budget_groups
1250: WHERE budget_group_type = 'R'
1251: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp
1252: AND ((effective_end_date IS NULL)
1253: OR

Line 1261: FROM psb_budget_groups

1257: )
1258: */
1259: AND EXISTS
1260: ( SELECT 1
1261: FROM psb_budget_groups
1262: WHERE budget_group_type = 'R'
1263: AND budget_group_id = accts.budget_group_id
1264: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp
1265: AND ((effective_end_date IS NULL)

Line 1327: FROM psb_budget_groups bg

1323: FROM psb_ws_account_lines acct_lines
1324: WHERE acct_lines.budget_group_id IN
1325: (
1326: SELECT bg.budget_group_id
1327: FROM psb_budget_groups bg
1328: WHERE bg.budget_group_type = 'R'
1329: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp
1330: AND ((effective_end_date IS NULL)
1331: OR

Line 1348: FROM psb_budget_groups bg

1344: WHERE acct_lines.position_line_id = lines.position_line_id
1345: AND EXISTS
1346: (
1347: SELECT bg.budget_group_id
1348: FROM psb_budget_groups bg
1349: WHERE bg.budget_group_type = 'R'
1350: AND budget_group_id = acct_lines.budget_group_id
1351: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp
1352: AND ((effective_end_date IS NULL)

Line 1473: l_main_budget_group_name psb_budget_groups.name%TYPE ;

1469: --
1470: l_worksheet_name psb_worksheets.name%TYPE ;
1471: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;
1472: l_worksheet_description psb_worksheets.description%TYPE ;
1473: l_main_budget_group_name psb_budget_groups.name%TYPE ;
1474: l_new_worksheet_id psb_worksheets.worksheet_id%TYPE ;
1475: l_new_position_line_id psb_ws_lines_positions.position_line_id%TYPE ;
1476: l_new_fte_line_id psb_ws_fte_lines.fte_line_id%TYPE ;
1477: l_new_element_line_id psb_ws_element_lines.element_line_id%TYPE ;

Line 1545: FROM psb_budget_groups

1541: --
1542: -- Finding the main budget group name.
1543: --
1544: SELECT name INTO l_main_budget_group_name
1545: FROM psb_budget_groups
1546: WHERE budget_group_id = l_ws_row_type.budget_group_id ;
1547:
1548: --
1549: -- Get worksheet description.

Line 5168: psb_budget_groups bg

5164: l_global_worksheet_id ,
5165: l_global_worksheet_flag ,
5166: l_parent_budget_group_id
5167: FROM psb_worksheets ws,
5168: psb_budget_groups bg
5169: WHERE ws.worksheet_id = p_worksheet_id
5170: AND ws.budget_group_id = bg.budget_group_id ;
5171:
5172: IF (l_global_worksheet_flag = 'Y') OR (l_parent_budget_group_id IS NULL) THEN

Line 5530: FROM psb_budget_groups

5526: --
5527: FOR l_budget_group_rec IN
5528: (
5529: SELECT budget_group_id
5530: FROM psb_budget_groups
5531: WHERE budget_group_type = 'R'
5532: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp
5533: AND ((effective_end_date IS NULL)
5534: OR

Line 5838: FROM psb_budget_groups

5834: /*For Bug No : 2236283 Start*/
5835: /*
5836: AND accts.budget_group_id IN
5837: ( SELECT budget_group_id
5838: FROM psb_budget_groups
5839: WHERE budget_group_type = 'R'
5840: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp
5841: AND ((effective_end_date IS NULL)
5842: OR

Line 5850: FROM psb_budget_groups

5846: )
5847: */
5848: AND EXISTS
5849: ( SELECT 1
5850: FROM psb_budget_groups
5851: WHERE budget_group_type = 'R'
5852: AND budget_group_id = accts.budget_group_id
5853: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp
5854: AND ((effective_end_date IS NULL)

Line 5922: FROM psb_budget_groups bg

5918: FROM psb_ws_account_lines acct_lines
5919: WHERE acct_lines.budget_group_id IN
5920: (
5921: SELECT bg.budget_group_id
5922: FROM psb_budget_groups bg
5923: WHERE bg.budget_group_type = 'R'
5924: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp
5925: AND ((effective_end_date IS NULL)
5926: OR

Line 5941: FROM psb_budget_groups bg

5937: WHERE acct_lines.position_line_id = lines.position_line_id
5938: AND EXISTS
5939: (
5940: SELECT 1
5941: FROM psb_budget_groups bg
5942: WHERE bg.budget_group_type = 'R'
5943: AND bg.budget_group_id = acct_lines.budget_group_id
5944: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp
5945: AND ((effective_end_date IS NULL)

Line 6647: l_main_budget_group_name psb_budget_groups.name%TYPE ;

6643: l_worksheet_name psb_worksheets.name%TYPE ;
6644: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;
6645: l_worksheet_description psb_worksheets.description%TYPE ;
6646: l_main_budget_group_id psb_worksheets.budget_group_id%TYPE ;
6647: l_main_budget_group_name psb_budget_groups.name%TYPE ;
6648: l_main_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;
6649: l_new_worksheet_id psb_worksheets.worksheet_id%TYPE ;
6650: l_global_worksheet_id psb_worksheets.worksheet_id%TYPE ;
6651: l_service_package_count NUMBER ;

Line 6708: FROM psb_budget_groups

6704: --
6705: -- Finding the budget group name for the worksheet.
6706: --
6707: SELECT name INTO l_main_budget_group_name
6708: FROM psb_budget_groups
6709: WHERE budget_group_id = l_main_budget_group_id ;
6710:
6711: --
6712: -- Get translated messages for the new worksheet.