APPS.PSB_POSITION_ATTRIBUTES_PVT dependencies on DUAL

Line 1206: FROM dual)

1202: END IF;
1203:
1204: FOR l_attribute_id_rec IN
1205: (SELECT psb_attributes_s.nextval attribute_id
1206: FROM dual)
1207: LOOP
1208: l_attribute_id := l_attribute_id_rec.attribute_id;
1209: END LOOP;
1210:

Line 1295: from dual;

1291: if (nvl(Temp_Type,'NULL') <> 'JOB_CLASS') then
1292:
1293: select psb_attributes_s.nextval
1294: into Temp_ID
1295: from dual;
1296:
1297: INSERT INTO PSB_ATTRIBUTES (
1298: ATTRIBUTE_ID,
1299: BUSINESS_GROUP_ID,

Line 1400: from dual;

1396:
1397: if (nvl(Temp_Type, 'NULL') <> 'FTE') then
1398: select psb_attributes_s.nextval
1399: into Temp_ID
1400: from dual;
1401:
1402: INSERT INTO PSB_ATTRIBUTES (
1403: ATTRIBUTE_ID,
1404: BUSINESS_GROUP_ID,

Line 1529: from dual;

1525: End Loop;
1526:
1527: select psb_attributes_s.nextval
1528: into Temp_ID
1529: from dual;
1530:
1531: INSERT INTO PSB_ATTRIBUTES (
1532: ATTRIBUTE_ID,
1533: BUSINESS_GROUP_ID,

Line 1635: from dual;

1631:
1632: if (nvl(Temp_Type, 'NULL') <> 'HIREDATE') then
1633: select psb_attributes_s.nextval
1634: into Temp_ID
1635: from dual;
1636:
1637:
1638: INSERT INTO PSB_ATTRIBUTES (
1639: ATTRIBUTE_ID,

Line 1737: from dual;

1733:
1734: if (nvl(Temp_Type, 'NULL') <> 'ADJUSTMENT_DATE') then
1735: select psb_attributes_s.nextval
1736: into Temp_ID
1737: from dual;
1738:
1739:
1740: INSERT INTO PSB_ATTRIBUTES (
1741: ATTRIBUTE_ID,

Line 1836: from dual;

1832:
1833: if (nvl(Temp_Type, 'NULL') <> 'DEFAULT_WEEKLY_HOURS') then
1834: select psb_attributes_s.nextval
1835: into Temp_ID
1836: from dual;
1837:
1838:
1839: INSERT INTO PSB_ATTRIBUTES (
1840: ATTRIBUTE_ID,