APPS.PSB_WS_ACCT2 dependencies on PSB_WS_LINES

Line 1751: FROM PSB_WS_LINES b

1747: AND p_start_stage_seq BETWEEN start_stage_seq AND current_stage_seq
1748: AND balance_type = 'A'
1749: AND EXISTS
1750: (SELECT 1
1751: FROM PSB_WS_LINES b
1752: WHERE b.account_line_id = a.account_line_id
1753: AND b.worksheet_id = p_worksheet_id)
1754: AND stage_set_id = p_stage_set_id
1755: AND service_package_id = p_service_package_id

Line 1785: FROM PSB_WS_LINES b

1781: AND p_start_stage_seq BETWEEN start_stage_seq AND current_stage_seq
1782: AND balance_type = 'E'
1783: AND EXISTS
1784: (SELECT 1
1785: FROM PSB_WS_LINES b
1786: WHERE b.account_line_id = a.account_line_id
1787: AND b.worksheet_id = p_worksheet_id)
1788: AND stage_set_id = p_stage_set_id
1789: AND service_package_id = p_service_package_id

Line 3219: from PSB_WS_LINES

3215: and c.budget_period_type = 'Y'
3216: and c.budget_year_type_id = p_budget_year_type_id)
3217: and exists
3218: (select 1
3219: from PSB_WS_LINES
3220: where account_line_id = a.account_line_id
3221: and worksheet_id = p_worksheet_id);
3222: */
3223:

Line 3228: PSB_WS_LINES d,

3224: -- commented as a part of bug fix 4256345
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

Line 3280: PSB_WS_LINES WSL

3276: SUM(NVL(A.YTD_AMOUNT, 0)) YTD_AMOUNT
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

Line 4108: FROM PSB_WS_LINES a,

4104: c.end_date,
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

Line 5990: 'from PSB_WS_LINES ' ||

5986: 'and a.code_combination_id = ' || l_mapped_ccid || ' ' ||
5987: 'and a.currency_code = ''' || p_currency_code || ''' ' ||
5988: 'and exists ' ||
5989: '(select 1 ' ||
5990: 'from PSB_WS_LINES ' ||
5991: 'where account_line_id = a.account_line_id ' ||
5992: 'and worksheet_id = ' || p_worksheet_id || ') ' ||
5993: 'and exists ' ||
5994: '(select 1 ' ||

Line 7745: from PSB_WS_LINES

7741: where f.budget_group_id = b.budget_group_id
7742: and (f.budget_group_id = p_budget_group_id or f.root_budget_group_id = p_budget_group_id))
7743: and exists
7744: (select 1
7745: from PSB_WS_LINES
7746: where account_line_id = b.account_line_id
7747: and worksheet_id = p_worksheet_id)
7748: and exists
7749: (select 1

Line 7778: from PSB_WS_LINES

7774: and a.budget_year_id = YearID
7775: /*For Bug No : 2586618 Start*/
7776: and a.template_id is null
7777: and exists (select 1
7778: from PSB_WS_LINES
7779: where account_line_id = a.account_line_id
7780: and worksheet_id = p_worksheet_id)
7781: /*For Bug No : 2586618 End*/
7782: and b.summary_code_combination_id = SumCCID