APPS.PSB_HR_POPULATE_DATA_PVT dependencies on PSB_ATTRIBUTES_VL

Line 810: from psb_attributes_vl

806: Select attribute_id,name,definition_type,definition_structure,
807: definition_table, definition_column,system_attribute_type,
808: attribute_type_id,data_type,
809: nvl(value_table_flag,'N') value_table_flag
810: from psb_attributes_vl
811: where business_group_id = p_business_group_id
812: -- Added for Bug#2820825
813: and (system_attribute_type is null OR system_attribute_type <> 'HIREDATE');
814:

Line 8503: FROM psb_attribute_values_i b, psb_attributes_vl a

8499:
8500: Cursor C_Attrval IS
8501: Select b.attribute_value_id,b.attribute_id,
8502: a.name, b.attribute_value,b.description,b.value_id
8503: FROM psb_attribute_values_i b, psb_attributes_vl a
8504: WHERE data_extract_id = p_data_extract_id
8505: AND b.attribute_id = a.attribute_id
8506: AND b.attribute_value_id > l_restart_attribute_value_id
8507: order by b.attribute_value_id;

Line 9253: -- Find attribute inFORmation FROM psb_attributes_vl based on current

9249:
9250: -- lp_max_flag determines whether a position_id exISts FOR the current
9251: -- C_Assignment_Rec.hr_employee_id.
9252: lp_max_flag := 'N';
9253: -- Find attribute inFORmation FROM psb_attributes_vl based on current
9254: -- attribute name.
9255: FOR C_pos_attr_rec in
9256: (
9257: Select attribute_id ,

Line 9260: FROM psb_attributes_VL

9256: (
9257: Select attribute_id ,
9258: nvl(value_table_flag ,'N') value_table_flag ,
9259: definition_type
9260: FROM psb_attributes_VL
9261: WHERE business_group_id = p_business_group_id
9262: AND name = lp_attribute_name
9263: )
9264: LOOP