APPS.PSB_POSITION_CONTROL_PVT dependencies on PSB_DATA_EXTRACTS

Line 512: from PSB_DATA_EXTRACTS

508: l_business_group_id NUMBER;
509:
510: cursor c_extract is
511: select business_group_id
512: from PSB_DATA_EXTRACTS
513: where data_extract_id = p_source_data_extract_id;
514: Bug No 2579818 End */
515:
516: cursor c_elem is

Line 5719: PSB_DATA_EXTRACTS b

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:
5723: cursor c_root_budget_group is

Line 5816: INSERT INTO PSB_DATA_EXTRACTS

5812:
5813: l_data_extract_name := fnd_message.get_string( 'PSB',
5814: 'PSB_SYSTEM_DATA_EXTRACT_NAME')||' '||l_root_short_name;
5815:
5816: INSERT INTO PSB_DATA_EXTRACTS
5817: (DATA_EXTRACT_ID, DATA_EXTRACT_NAME, DATA_EXTRACT_METHOD,
5818: SET_OF_BOOKS_ID, BUSINESS_GROUP_ID, BUDGET_GROUP_ID,
5819: POSITION_ID_FLEX_NUM, BASE_SALARY_DATE, REQ_DATA_AS_OF_DATE,
5820: LAST_EXTRACT_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY,

Line 5822: VALUES (PSB_DATA_EXTRACTS_S.NEXTVAL, l_data_extract_name, 'CREATE',

5818: SET_OF_BOOKS_ID, BUSINESS_GROUP_ID, BUDGET_GROUP_ID,
5819: POSITION_ID_FLEX_NUM, BASE_SALARY_DATE, REQ_DATA_AS_OF_DATE,
5820: LAST_EXTRACT_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
5821: LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE, SYSTEM_DATA_EXTRACT)
5822: VALUES (PSB_DATA_EXTRACTS_S.NEXTVAL, l_data_extract_name, 'CREATE',
5823: l_root_set_of_books_id, l_business_group_id, l_root_budget_group_id,
5824: l_position_id_flex_num, null, sysdate,
5825: sysdate, sysdate, FND_GLOBAL.USER_ID,
5826: FND_GLOBAL.LOGIN_ID, FND_GLOBAL.USER_ID, sysdate, 'Y') RETURNING data_extract_id into l_system_data_extract_id;

Line 6079: psb_data_extracts b

6075:
6076: -- This cursor gets the Attribute id for the business group
6077: -- associated with the data extract.
6078: FOR l_att_fte_rec IN (SELECT attribute_id FROM psb_attributes a,
6079: psb_data_extracts b
6080: WHERE a.business_group_id = b.business_group_id
6081: AND a.system_attribute_type = 'FTE'
6082: AND b.data_extract_id = l_data_extract_Id)
6083: LOOP

Line 10936: from psb_data_extracts

10932:
10933: /*For Bug No : 2434152 Start*/
10934: cursor c_sob_id is
10935: select set_of_books_id
10936: from psb_data_extracts
10937: where data_extract_id = p_system_data_extract_id;
10938: /*For Bug No : 2434152 End*/
10939:
10940: c_pqh_budget_details_rec c_pqh_budget_details%ROWTYPE;