APPS.PSB_HR_EXTRACT_DATA_PVT dependencies on PSB_ATTRIBUTE_TYPES

Line 3580: from psb_attribute_types

3576:
3577: Cursor C_table is
3578: Select name,select_column,
3579: substr(select_table,1,instr(select_table,' ',1)) select_table
3580: from psb_attribute_types
3581: where attribute_type_id = l_attribute_type_id;
3582:
3583: Cursor C_Attribute is
3584: Select attribute_value_id

Line 4587: From Psb_attribute_types

4583: select_column,select_key,
4584: link_key,decode(link_type,'A','PER_ALL_ASSIGNMENTS','E',
4585: 'PER_ALL_PEOPLE','P', 'HR_ALL_POSITIONS','PER_ALL_ASSIGNMENTS') link_type,link_type l_alias2,
4586: select_where
4587: From Psb_attribute_types
4588: Where attribute_type = d_attribute_type
4589: and attribute_type_id = d_attribute_type_id;
4590:
4591: Cursor C_key_33 is

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 7168: From Psb_attribute_types

7164: link_key,decode(link_type,'A','PER_ALL_ASSIGNMENTS','E',
7165: 'PER_ALL_PEOPLE','P', 'HR_ALL_POSITIONS','PER_ALL_ASSIGNMENTS')
7166: link_type,link_type l_alias2,
7167: select_where
7168: From Psb_attribute_types
7169: where attribute_type_id = p_attribute_type_id;
7170:
7171: Cursor C_dff_tab is
7172: Select application_id,application_table_name,