APPS.PSB_ENTITY_SET_PVT dependencies on PSB_ATTRIBUTES

Line 692: l_value_table_flag psb_attributes.value_table_flag%TYPE;

688: l_attribute_id psb_attribute_values.attribute_id%TYPE;
689: l_attribute_value_id psb_attribute_values.attribute_value_id%TYPE;
690: l_attribute_value psb_attribute_values.attribute_value%TYPE;
691: l_create_formula_flag VARCHAR2(1);
692: l_value_table_flag psb_attributes.value_table_flag%TYPE;
693: l_source_option_flag psb_pay_elements.option_flag%TYPE;
694: l_source_salary_flag psb_pay_elements.salary_flag%TYPE;
695: l_source_pay_element_id psb_pay_elements.pay_element_id%TYPE;
696: l_source_pay_element_option_id

Line 1197: FROM psb_attributes

1193: l_attribute_value_id := NULL;
1194:
1195: -- Find if the value table exists for the attribute.
1196: SELECT NVL(value_table_flag, 'N') INTO l_value_table_flag
1197: FROM psb_attributes
1198: WHERE attribute_id = l_attribute_id ;
1199:
1200: IF l_value_table_flag = 'Y' THEN
1201:

Line 1790: psb_attributes attrs,

1786: psb_set_relations rels,
1787: psb_account_position_sets sets,
1788: psb_account_position_set_lines lines,
1789: psb_position_set_line_values pos_val,
1790: psb_attributes attrs,
1791: psb_attribute_values attr_values
1792: WHERE assgn.entity_set_id = p_source_entity_set_id
1793: and assgn.entity_id = entity.entity_id
1794: and entity.entity_subtype = 'POSITION'

Line 1813: psb_attributes attrs,

1809: SELECT DISTINCT formulas.attribute_id, attr_values.attribute_value
1810: FROM psb_entity_assignment assgn,
1811: psb_entity entity,
1812: psb_parameter_formulas formulas,
1813: psb_attributes attrs,
1814: psb_attribute_values attr_values
1815: WHERE assgn.entity_set_id = p_source_entity_set_id
1816: and assgn.entity_id = entity.entity_id
1817: and entity.entity_subtype = 'POSITION'

Line 1828: FROM psb_attributes attrs,

1824: );
1825:
1826: CURSOR l_attribute_value_csr IS
1827: SELECT attr_values.*
1828: FROM psb_attributes attrs,
1829: psb_attribute_values attr_values
1830: WHERE attrs.value_table_flag = 'Y'
1831: and attrs.attribute_id = l_attribute_id
1832: and attr_values.attribute_value = l_attribute_value

Line 1881: FROM psb_attributes attrs,

1877: l_attribute_id := l_attr_value_rec.attribute_id;
1878: l_attribute_value := l_attr_value_rec.attribute_value;
1879:
1880: SELECT count(*) into l_count
1881: FROM psb_attributes attrs,
1882: psb_attribute_values attr_values
1883: WHERE attrs.value_table_flag = 'Y'
1884: and attrs.attribute_id = l_attribute_id
1885: and attr_values.attribute_value = l_attribute_value