APPS.PSB_POSITION_CONTROL_PVT dependencies on PSB_WORKSHEETS

Line 5517: select data_extract_id from psb_worksheets where worksheet_id = p_source_id;

5513: l_msg_count NUMBER;
5514: l_msg_data VARCHAR2(2000);
5515:
5516: cursor c_bp is
5517: select data_extract_id from psb_worksheets where worksheet_id = p_source_id;
5518:
5519: cursor c_revision is
5520: select budget_group_id from psb_budget_revisions where budget_revision_id = p_source_id;
5521:

Line 5718: from PSB_WORKSHEETS a,

5714: b.position_id_flex_num,
5715: a.budget_calendar_id,
5716: a.budget_group_id,
5717: a.flex_mapping_set_id
5718: from PSB_WORKSHEETS a,
5719: PSB_DATA_EXTRACTS b
5720: where a.worksheet_id = p_worksheet_id
5721: and b.data_extract_id = a.data_extract_id;
5722:

Line 6070: FROM psb_worksheets

6066:
6067: IF g_hrms_fte_upload_option = 'ASSIGNMENT' THEN
6068: -- fetch the data extract used for position worksheet
6069: FOR l_data_extract_rec IN (SELECT data_extract_id
6070: FROM psb_worksheets
6071: WHERE worksheet_id = p_worksheet_id)
6072: LOOP
6073: l_data_extract_Id := l_data_extract_rec.data_extract_id;
6074: END LOOP;

Line 11605: from PSB_WORKSHEETS

11601: where budget_group_id = l_budget_group_id;
11602:
11603: cursor c_WS is
11604: select budget_calendar_id, budget_group_id, data_extract_id
11605: from PSB_WORKSHEETS
11606: where worksheet_id = p_source_id;
11607:
11608: cursor c_BR is
11609: select budget_group_id