APPS.PSB_HR_POPULATE_DATA_PVT dependencies on PSB_DATA_EXTRACTS

Line 1654: FROM psb_data_extracts

1650: SELECT business_group_id,
1651: set_of_books_id,
1652: position_id_flex_num,
1653: req_data_as_of_date
1654: FROM psb_data_extracts
1655: WHERE data_extract_id = l_data_extract_id;
1656:
1657: /*For Bug No : 2602027 Start*/
1658: Cursor C_flex_num is

Line 2212: FROM psb_data_extracts

2208: SELECT req_data_as_of_date,
2209: set_of_books_id,
2210: position_id_flex_num,
2211: business_group_id
2212: FROM psb_data_extracts
2213: WHERE data_extract_id = l_data_extract_id;
2214:
2215: l_trn_exist VARCHAR2(1) := FND_API.G_FALSE;
2216: l_psb_position_id number := '';

Line 2883: FROM psb_data_extracts

2879: SELECT business_group_id,
2880: set_of_books_id,
2881: position_id_flex_num,
2882: req_data_as_of_date
2883: FROM psb_data_extracts
2884: WHERE data_extract_id = l_data_extract_id;
2885:
2886: /*For Bug No : 2602027 Start*/
2887: Cursor C_flex_num is

Line 3505: FROM psb_data_extracts

3501: SELECT business_group_id,
3502: set_of_books_id,
3503: position_id_flex_num,
3504: req_data_as_of_date
3505: FROM psb_data_extracts
3506: WHERE data_extract_id = l_data_extract_id;
3507:
3508: /*For Bug No : 2602027 Start*/
3509: Cursor C_flex_num is

Line 6474: -- Bug # 4886277: Used psb_data_extracts instead of

6470: /* start bug no 4213882 */
6471: l_assignment_rec_no := 0;
6472: l_assignment_exists := FALSE;
6473:
6474: -- Bug # 4886277: Used psb_data_extracts instead of
6475: -- fnd_sessions to get req_data_as_of_date.
6476: FOR l_assignment_rec IN
6477: (SELECT a.effective_start_date,
6478: a.effective_end_date

Line 6480: psb_data_extracts b

6476: FOR l_assignment_rec IN
6477: (SELECT a.effective_start_date,
6478: a.effective_end_date
6479: FROM per_all_assignments_f a,
6480: psb_data_extracts b
6481: WHERE a.position_id =l_position_i_cache(i).hr_position_id
6482: AND a.person_id = l_position_i_cache(i).hr_employee_id
6483: AND b.data_extract_id = p_data_extract_id
6484: AND b.req_data_as_of_date between

Line 6499: -- Bug # 4886277: Used psb_data_extracts instead of

6495: END IF;
6496: END LOOP;
6497:
6498: IF NOT l_assignment_exists THEN
6499: -- Bug # 4886277: Used psb_data_extracts instead of
6500: -- fnd_sessions to get req_data_as_of_date.
6501: FOR l_hr_position_rec IN
6502: (SELECT a.effective_start_date,
6503: a.effective_end_date

Line 6505: psb_data_extracts b

6501: FOR l_hr_position_rec IN
6502: (SELECT a.effective_start_date,
6503: a.effective_end_date
6504: FROM hr_all_positions_f a,
6505: psb_data_extracts b
6506: WHERE a.position_id =l_position_i_cache(i).hr_position_id
6507: AND b.data_extract_id = p_data_extract_id
6508: AND b.req_data_as_of_date between
6509: a.effective_start_date AND a.effective_end_date)

Line 9657: UpDATE PSB_DATA_EXTRACTS

9653: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9654: RAISE FND_API.G_EXC_ERROR;
9655: END IF;
9656:
9657: UpDATE PSB_DATA_EXTRACTS
9658: set default_data_status = 'C'
9659: WHERE data_extract_id = p_data_extract_id;
9660:
9661: commit work;