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_ACCT2 dependencies on PSB_WS_ACCOUNT_LINES

Line 995: -- CCIDs with zero YTD Amounts should be created in PSB_WS_ACCOUNT_LINES

991: end if;
992:
993:
994: -- Create Zero Balances Profile Option : this specifies whether non-Position
995: -- CCIDs with zero YTD Amounts should be created in PSB_WS_ACCOUNT_LINES
996:
997: FND_PROFILE.GET
998: (name => 'PSB_CREATE_ZERO_BALANCE_ACCT',
999: val => g_create_zero_bal);

Line 1743: FROM PSB_WS_ACCOUNT_LINES a

1739: period45_amount, period46_amount, period47_amount, period48_amount,
1740: period49_amount, period50_amount, period51_amount, period52_amount,
1741: period53_amount, period54_amount, period55_amount, period56_amount,
1742: period57_amount, period58_amount, period59_amount, period60_amount
1743: FROM PSB_WS_ACCOUNT_LINES a
1744: WHERE template_id IS NULL
1745: AND position_line_id IS NULL
1746: AND currency_code = p_currency_code
1747: AND p_start_stage_seq BETWEEN start_stage_seq AND current_stage_seq

Line 1777: FROM PSB_WS_ACCOUNT_LINES a

1773: period45_amount, period46_amount, period47_amount, period48_amount,
1774: period49_amount, period50_amount, period51_amount, period52_amount,
1775: period53_amount, period54_amount, period55_amount, period56_amount,
1776: period57_amount, period58_amount, period59_amount, period60_amount
1777: FROM PSB_WS_ACCOUNT_LINES a
1778: WHERE template_id IS NULL
1779: AND position_line_id IS NULL
1780: AND currency_code = p_currency_code
1781: AND p_start_stage_seq BETWEEN start_stage_seq AND current_stage_seq

Line 3199: from PSB_WS_ACCOUNT_LINES a

3195: /* For Bug No. 2214715 : Start */
3196: /* Existing Cursor definition is commented and modified one is added as follows :
3197: cursor c_Type12 is
3198: select nvl(a.ytd_amount, 0) YTD_Amount
3199: from PSB_WS_ACCOUNT_LINES a
3200: where a.code_combination_id = l_mapped_ccid
3201: and a.currency_code = p_currency_code
3202: and a.balance_type = p_balance_type
3203: and a.service_package_id = p_service_package_id

Line 3229: PSB_WS_ACCOUNT_LINES a,

3225: /* cursor c_Type12 is
3226: select sum(nvl(a.ytd_amount, 0)) YTD_Amount
3227: from PSB_WORKSHEETS b,
3228: PSB_WS_LINES d,
3229: PSB_WS_ACCOUNT_LINES a,
3230: PSB_BUDGET_PERIODS c
3231: where b.worksheet_id = p_worksheet_id
3232: and d.worksheet_id = b.worksheet_id
3233: and d.account_line_id = a.account_line_id

Line 3281: , PSB_WS_ACCOUNT_LINES A

3277: INTO
3278: l_ytd_amount
3279: FROM
3280: PSB_WS_LINES WSL
3281: , PSB_WS_ACCOUNT_LINES A
3282: WHERE A.CODE_COMBINATION_ID = l_mapped_ccid
3283: AND A.BUDGET_YEAR_ID = l_budget_year_id
3284: AND A.SERVICE_PACKAGE_ID = p_service_package_id
3285: AND A.BALANCE_TYPE = p_balance_type

Line 4109: PSB_WS_ACCOUNT_LINES b,

4105: b.note_id,
4106: d.year_category_type,
4107: c.name -- Bug#4571412
4108: FROM PSB_WS_LINES a,
4109: PSB_WS_ACCOUNT_LINES b,
4110: PSB_BUDGET_PERIODS c,
4111: PSB_BUDGET_YEAR_TYPES d
4112: WHERE a.worksheet_id = p_worksheet_id
4113: AND b.account_line_id = a.account_line_id

Line 5982: 'from PSB_WS_ACCOUNT_LINES a ' ||

5978: 'period' || p_budget_periods(l_index).long_sequence_no || '_amount' || ', ';
5979: end loop;
5980:
5981: sql_alloc := substr(sql_alloc, 1, length(sql_alloc) -2) || ' ' ||
5982: 'from PSB_WS_ACCOUNT_LINES a ' ||
5983: 'where a.template_id is null ' ||
5984: 'and a.position_line_id is null ' ||
5985: 'and a.balance_type = ''' || c_AllocRule_Rec.balance_type || ''' ' ||
5986: 'and a.code_combination_id = ' || l_mapped_ccid || ' ' ||

Line 6183: from PSB_WS_ACCOUNT_LINES

6179: period57_amount, period58_amount, period59_amount, period60_amount,
6180: /* Bug No 2354918 Start */
6181: budget_year_id
6182: /* Bug No 2354918 End */
6183: from PSB_WS_ACCOUNT_LINES
6184: where account_line_id = p_account_line_id;
6185:
6186: BEGIN
6187:

Line 7730: PSB_WS_ACCOUNT_LINES b,

7726: sum(nvl(b.period10_amount, 0)) p10_amt,
7727: sum(nvl(b.period11_amount, 0)) p11_amt,
7728: sum(nvl(b.period12_amount, 0)) p12_amt
7729: from GL_ACCOUNT_HIERARCHIES a,
7730: PSB_WS_ACCOUNT_LINES b,
7731: PSB_SUMMARY_TEMPLATES c
7732: where a.detail_code_combination_id = b.code_combination_id
7733: and a.template_id = c.template_id
7734: and a.ledger_id = p_set_of_books_id

Line 7770: from PSB_WS_ACCOUNT_LINES a,

7766: cursor c_DtlCCID (SumCCID NUMBER,
7767: TemplateID NUMBER,
7768: YearID NUMBER) is
7769: select distinct a.budget_group_id
7770: from PSB_WS_ACCOUNT_LINES a,
7771: GL_ACCOUNT_HIERARCHIES b
7772: where p_current_stage_seq between a.start_stage_seq and a.current_stage_seq
7773: and a.code_combination_id = b.detail_code_combination_id
7774: and a.budget_year_id = YearID

Line 8083: -- Delete all Summary Account Lines from PSB_WS_ACCOUNT_LINES to obviate any changes

8079: then
8080: raise FND_API.G_EXC_UNEXPECTED_ERROR;
8081: end if;
8082:
8083: -- Delete all Summary Account Lines from PSB_WS_ACCOUNT_LINES to obviate any changes
8084: -- to the Summary Account - Detailed Account mappings in GL
8085:
8086: PSB_WORKSHEET.Delete_Summary_Lines
8087: (p_api_version => 1.0,