APPS.PSB_HR_EXTRACT_DATA_PVT dependencies on PSB_ATTRIBUTES_VL

Line 3487: FROM PSB_ATTRIBUTES_VL

3483: data_type,
3484: system_attribute_type,
3485: attribute_type_id,
3486: value_table_flag
3487: FROM PSB_ATTRIBUTES_VL
3488: WHERE business_group_id = p_business_group_id
3489: AND attribute_id > l_restart_attribute_id
3490: ORDER BY attribute_id;
3491:

Line 3572: l_data_type psb_attributes_vl.data_type%TYPE;

3568: l_msg_data varchar2(1000);
3569:
3570: /* Bug 4075170 Start */
3571: -- Local Variable that will hold the datatype of the attribute.
3572: l_data_type psb_attributes_vl.data_type%TYPE;
3573: l_param_info VARCHAR2(4000);
3574: l_debug_info VARCHAR2(4000);
3575: /* Bug 4075170 End */
3576:

Line 4391: from Psb_attributes_VL

4387: Cursor C_Emp_Attributes is
4388: Select attribute_id,name,definition_type,definition_structure,
4389: definition_table, definition_column,system_attribute_type,
4390: attribute_type_id,data_type
4391: from Psb_attributes_VL
4392: where business_group_id = p_business_group_id
4393: and attribute_id > l_restart_attribute_id;
4394:
4395: /*For Bug No : 2370607 Start*/

Line 4706: l_data_type psb_attributes_vl.data_type%TYPE;

4702: l_api_name CONSTANT VARCHAR2(30) := 'Get_Employee_Attributes';
4703: l_api_version CONSTANT NUMBER := 1.0;
4704:
4705: /* Bug 4075170 Start */
4706: l_data_type psb_attributes_vl.data_type%TYPE;
4707: l_param_info VARCHAR2(4000);
4708: l_debug_info VARCHAR2(4000);
4709: /* Bug 4075170 End */
4710:

Line 6066: from PSB_ATTRIBUTES_VL a, PSB_ATTRIBUTE_TYPES B

6062: l_link_type := null;
6063: FOR l_fte_link_rec IN
6064: (
6065: SELECT link_type
6066: from PSB_ATTRIBUTES_VL a, PSB_ATTRIBUTE_TYPES B
6067: WHERE a.business_group_id = p_business_group_id
6068: AND a.system_attribute_type = 'FTE'
6069: AND a.attribute_type_id = b.attribute_type_id
6070: )

Line 6089: FROM psb_attributes_VL

6085: AND hr_employee_id IS NOT NULL
6086: AND attribute_name IN
6087: (
6088: SELECT name
6089: FROM psb_attributes_VL
6090: WHERE system_attribute_type = 'FTE'
6091: AND business_group_id = p_business_group_id
6092: )
6093: GROUP BY hr_position_id