APPS.PSB_HR_EXTRACT_DATA_PVT dependencies on PSB_EMPLOYEE_ASSIGNMENTS_I

Line 5083: INSERT INTO PSB_EMPLOYEE_ASSIGNMENTS_I

5079: dbms_sql.column_value(v_cursorid,1,v_segment);
5080: if (v_segment is not null) then
5081: if (ctr = 1) then
5082:
5083: INSERT INTO PSB_EMPLOYEE_ASSIGNMENTS_I
5084: ( HR_POSITION_ID ,
5085: HR_EMPLOYEE_ID ,
5086: DATA_EXTRACT_ID ,
5087: ATTRIBUTE_NAME ,

Line 5249: INSERT INTO PSB_EMPLOYEE_ASSIGNMENTS_I

5245: ||', Atrribute Data Type '||l_data_type
5246: ||', Atrribute Value '||v_dsegment;
5247: /* Bug 4075170 End */
5248:
5249: INSERT INTO PSB_EMPLOYEE_ASSIGNMENTS_I
5250: ( HR_POSITION_ID ,
5251: HR_EMPLOYEE_ID ,
5252: DATA_EXTRACT_ID ,
5253: ATTRIBUTE_NAME ,

Line 5407: INSERT INTO PSB_EMPLOYEE_ASSIGNMENTS_I

5403: RAISE_APPLICATION_ERROR(-20001,l_message_text);
5404: end;
5405: end if;
5406:
5407: INSERT INTO PSB_EMPLOYEE_ASSIGNMENTS_I
5408: ( HR_POSITION_ID ,
5409: HR_EMPLOYEE_ID ,
5410: DATA_EXTRACT_ID ,
5411: ATTRIBUTE_NAME ,

Line 5580: INSERT INTO PSB_EMPLOYEE_ASSIGNMENTS_I

5576: end if;
5577:
5578: if (v_osegment is not null) then
5579:
5580: INSERT INTO PSB_EMPLOYEE_ASSIGNMENTS_I
5581: ( HR_POSITION_ID ,
5582: HR_EMPLOYEE_ID ,
5583: DATA_EXTRACT_ID ,
5584: ATTRIBUTE_NAME ,

Line 5654: INSERT INTO PSB_EMPLOYEE_ASSIGNMENTS_I

5650: Loop
5651: l_job_name := C_job_name_rec.name;
5652: End Loop;
5653:
5654: INSERT INTO PSB_EMPLOYEE_ASSIGNMENTS_I
5655: ( HR_POSITION_ID ,
5656: HR_EMPLOYEE_ID ,
5657: DATA_EXTRACT_ID ,
5658: ATTRIBUTE_NAME ,

Line 5692: INSERT INTO PSB_EMPLOYEE_ASSIGNMENTS_I

5688: Loop
5689: l_organization_name := C_Org_Rec.name;
5690: End Loop;
5691:
5692: INSERT INTO PSB_EMPLOYEE_ASSIGNMENTS_I
5693: ( HR_POSITION_ID ,
5694: HR_EMPLOYEE_ID ,
5695: DATA_EXTRACT_ID ,
5696: ATTRIBUTE_NAME ,

Line 5828: INSERT INTO PSB_EMPLOYEE_ASSIGNMENTS_I

5824: if (l_fte is not null) then
5825:
5826: lp_fte := fnd_number.number_to_canonical(l_fte);
5827:
5828: INSERT INTO PSB_EMPLOYEE_ASSIGNMENTS_I
5829: ( HR_POSITION_ID ,
5830: HR_EMPLOYEE_ID ,
5831: DATA_EXTRACT_ID ,
5832: ATTRIBUTE_NAME ,

Line 5927: INSERT INTO PSB_EMPLOYEE_ASSIGNMENTS_I

5923: end if;
5924:
5925: /*For Bug No : 2370607 End*/
5926:
5927: INSERT INTO PSB_EMPLOYEE_ASSIGNMENTS_I
5928: ( HR_POSITION_ID ,
5929: HR_EMPLOYEE_ID ,
5930: DATA_EXTRACT_ID ,
5931: ATTRIBUTE_NAME ,

Line 5993: INSERT INTO PSB_EMPLOYEE_ASSIGNMENTS_I

5989:
5990:
5991: if (l_hiredate is not null) then
5992: lp_hiredate := fnd_date.date_to_canonical(l_hiredate);
5993: INSERT INTO PSB_EMPLOYEE_ASSIGNMENTS_I
5994: ( HR_POSITION_ID ,
5995: HR_EMPLOYEE_ID ,
5996: DATA_EXTRACT_ID ,
5997: ATTRIBUTE_NAME ,

Line 6082: FROM psb_employee_assignments_i

6078: (
6079: SELECT hr_position_id ,
6080: MAX(attribute_value) total_fte ,
6081: COUNT(hr_employee_id) total_employees
6082: FROM psb_employee_assignments_i
6083: WHERE data_extract_id = p_data_extract_id
6084: AND attribute_value IS NOT NULL
6085: AND hr_employee_id IS NOT NULL
6086: AND attribute_name IN

Line 6109: FROM psb_employee_assignments_i

6105: -- pooled positions.
6106: FOR l_emp_rec IN
6107: ( SELECT ROWID,
6108: ROWNUM
6109: FROM psb_employee_assignments_i
6110: WHERE hr_position_id = l_emp_assgn_rec.hr_position_id
6111: AND data_extract_id = p_data_extract_id
6112: AND attribute_value IS NOT NULL
6113: AND hr_employee_id IS NOT NULL

Line 6135: UPDATE psb_employee_assignments_i

6131: l_fte := l_average_fte ;
6132: END IF ;
6133:
6134: -- Update the FTE information.
6135: UPDATE psb_employee_assignments_i
6136: SET attribute_value = l_fte
6137: WHERE rowid = l_emp_rec.rowid ;
6138:
6139: l_allocated_fte := l_allocated_fte + l_fte ;