APPS.PSB_WORKSHEET_CONSOLIDATE dependencies on PSB_ATTRIBUTES

Line 105: select PSB_ATTRIBUTES_S.NEXTVAL seq

101:
102: l_return_status VARCHAR2(1);
103:
104: cursor c_attr_seq is
105: select PSB_ATTRIBUTES_S.NEXTVAL seq
106: from dual;
107:
108: cursor c_attrval_seq is
109: select PSB_ATTRIBUTE_VALUES_S.NEXTVAL seq

Line 114: from PSB_ATTRIBUTES

110: from dual;
111:
112: cursor c_attr is
113: select *
114: from PSB_ATTRIBUTES
115: where business_group_id = p_local_business_group_id;
116:
117: cursor c_attrname_exists (attrname VARCHAR2) is
118: select attribute_id

Line 119: from PSB_ATTRIBUTES

115: where business_group_id = p_local_business_group_id;
116:
117: cursor c_attrname_exists (attrname VARCHAR2) is
118: select attribute_id
119: from PSB_ATTRIBUTES
120: where name = attrname
121: and business_group_id = g_global_business_group_id;
122:
123: cursor c_attrval (attrid NUMBER) is

Line 474: from PSB_ATTRIBUTES a,

470: and line_sequence_id = lineseqid;
471:
472: cursor c_re_attr (attrid NUMBER) is
473: select a.attribute_id
474: from PSB_ATTRIBUTES a,
475: PSB_ATTRIBUTES b
476: where a.business_group_id = g_global_business_group_id
477: and a.name = b.name
478: and b.attribute_id = attrid;

Line 475: PSB_ATTRIBUTES b

471:
472: cursor c_re_attr (attrid NUMBER) is
473: select a.attribute_id
474: from PSB_ATTRIBUTES a,
475: PSB_ATTRIBUTES b
476: where a.business_group_id = g_global_business_group_id
477: and a.name = b.name
478: and b.attribute_id = attrid;
479:

Line 1460: from PSB_ATTRIBUTES a,

1456: and position_id = positionid;
1457:
1458: cursor c_re_attr (attrid NUMBER) is
1459: select a.attribute_id
1460: from PSB_ATTRIBUTES a,
1461: PSB_ATTRIBUTES b
1462: where a.business_group_id = g_global_business_group_id
1463: and a.name = b.name
1464: and b.attribute_id = attrid;

Line 1461: PSB_ATTRIBUTES b

1457:
1458: cursor c_re_attr (attrid NUMBER) is
1459: select a.attribute_id
1460: from PSB_ATTRIBUTES a,
1461: PSB_ATTRIBUTES b
1462: where a.business_group_id = g_global_business_group_id
1463: and a.name = b.name
1464: and b.attribute_id = attrid;
1465: