APPS.PSB_WS_ACCT1 dependencies on PSB_WS_SUBMIT_SERVICE_PACKAGES

Line 5470: from PSB_WS_SUBMIT_SERVICE_PACKAGES d

5466: where account_line_id = a.account_line_id
5467: and worksheet_id = p_worksheet_id)
5468: and exists
5469: (select 1
5470: from PSB_WS_SUBMIT_SERVICE_PACKAGES d
5471: where d.service_package_id = a.service_package_id
5472: and d.worksheet_id = p_worksheet_id);
5473: */
5474:

Line 5500: from PSB_WS_SUBMIT_SERVICE_PACKAGES e

5496: and c.budget_period_type = 'Y'
5497: and c.budget_year_type_id = p_budget_year_type_id
5498: and exists
5499: (select 1
5500: from PSB_WS_SUBMIT_SERVICE_PACKAGES e
5501: where e.service_package_id = a.service_package_id
5502: and e.worksheet_id = p_worksheet_id); */
5503:
5504: /* For Bug No. 2214715 : End */

Line 5537: FROM PSB_WS_SUBMIT_SERVICE_PACKAGES S

5533: BETWEEN A.START_STAGE_SEQ AND A.CURRENT_STAGE_SEQ
5534: AND WSL.WORKSHEET_ID = p_worksheet_id
5535: AND WSL.ACCOUNT_LINE_ID = A.ACCOUNT_LINE_ID
5536: AND EXISTS( SELECT 1
5537: FROM PSB_WS_SUBMIT_SERVICE_PACKAGES S
5538: WHERE S.SERVICE_PACKAGE_ID = A.SERVICE_PACKAGE_ID
5539: AND S.WORKSHEET_ID = p_worksheet_id))
5540: LOOP
5541: l_ytd_amount := l_ytd_amount + l_ytd_rec.ytd_amount;

Line 5625: from PSB_WS_SUBMIT_SERVICE_PACKAGES c

5621: from PSB_WS_ACCOUNT_LINES a,
5622: PSB_WORKSHEETS b
5623: where exists
5624: (select 1
5625: from PSB_WS_SUBMIT_SERVICE_PACKAGES c
5626: where c.service_package_id = a.service_package_id
5627: and c.worksheet_id = p_worksheet_id)
5628: and exists
5629: (select 1

Line 7021: from PSB_WS_SUBMIT_SERVICE_PACKAGES

7017: select 'x'
7018: from dual
7019: where exists
7020: (select 'Service Package Exists'
7021: from PSB_WS_SUBMIT_SERVICE_PACKAGES
7022: where worksheet_id = p_worksheet_id);
7023:
7024:
7025: l_api_name CONSTANT VARCHAR2(30) := 'Apply_Account_Constraints';