APPS.PSB_WS_POS3 dependencies on PSB_WS_SUBMIT_SERVICE_PACKAGES

Line 4784: from PSB_WS_SUBMIT_SERVICE_PACKAGES

4780: select 'x'
4781: from dual
4782: where exists
4783: (select 'Service Package Exists'
4784: from PSB_WS_SUBMIT_SERVICE_PACKAGES
4785: where worksheet_id = p_worksheet_id);
4786:
4787: BEGIN
4788:

Line 5362: from PSB_WS_SUBMIT_SERVICE_PACKAGES g

5358: and e.account_position_set_id = f.account_position_set_id
5359: and f.constraint_id = p_constraint_id)
5360: and exists
5361: (select 1
5362: from PSB_WS_SUBMIT_SERVICE_PACKAGES g
5363: where g.service_package_id = a.service_package_id
5364: and g.worksheet_id = p_worksheet_id)
5365: and b.current_stage_seq between a.start_stage_seq and a.current_stage_seq
5366: and a.currency_code = p_currency_code

Line 5392: from PSB_WS_SUBMIT_SERVICE_PACKAGES h

5388: and f.account_position_set_id = g.account_position_set_id
5389: and g.constraint_id = p_constraint_id)
5390: and exists
5391: (select 1
5392: from PSB_WS_SUBMIT_SERVICE_PACKAGES h
5393: where h.service_package_id = a.service_package_id
5394: and h.worksheet_id = p_worksheet_id)
5395: and b.current_stage_seq between a.start_stage_seq and a.current_stage_seq
5396: and a.currency_code = p_currency_code

Line 5444: from PSB_WS_SUBMIT_SERVICE_PACKAGES d

5440: from PSB_WS_ELEMENT_LINES a,
5441: PSB_WORKSHEETS b
5442: where exists
5443: (select 1
5444: from PSB_WS_SUBMIT_SERVICE_PACKAGES d
5445: where d.service_package_id = a.service_package_id
5446: and d.worksheet_id = p_worksheet_id)
5447: and a.currency_code = p_currency_code
5448: and a.stage_set_id = b.stage_set_id

Line 5463: from PSB_WS_SUBMIT_SERVICE_PACKAGES d

5459: PSB_WORKSHEETS b,
5460: PSB_PAY_ELEMENTS c
5461: where exists
5462: (select 1
5463: from PSB_WS_SUBMIT_SERVICE_PACKAGES d
5464: where d.service_package_id = a.service_package_id
5465: and d.worksheet_id = p_worksheet_id)
5466: and a.currency_code = p_currency_code
5467: and a.stage_set_id = b.stage_set_id

Line 5923: from PSB_WS_SUBMIT_SERVICE_PACKAGES g

5919: and e.account_position_set_id = f.account_position_set_id
5920: and f.constraint_id = p_constraint_id)
5921: and exists
5922: (select 1
5923: from PSB_WS_SUBMIT_SERVICE_PACKAGES g
5924: where g.service_package_id = a.service_package_id
5925: and g.worksheet_id = p_worksheet_id)
5926: and b.current_stage_seq between a.start_stage_seq and a.current_stage_seq
5927: and a.stage_set_id = b.stage_set_id

Line 5949: from PSB_WS_SUBMIT_SERVICE_PACKAGES d

5945: from PSB_WS_FTE_LINES a,
5946: PSB_WORKSHEETS b
5947: where exists
5948: (select 1
5949: from PSB_WS_SUBMIT_SERVICE_PACKAGES d
5950: where d.worksheet_id = p_worksheet_id
5951: and d.service_package_id = a.service_package_id)
5952: and b.current_stage_seq between a.start_stage_seq and a.current_stage_seq
5953: and a.stage_set_id = b.stage_set_id