APPS.PSB_COPY_DATA_EXTRACT_PVT dependencies on DUAL

Line 185: l_attribute_value_id from dual;

181:
182: if (l_attr_dummy = 0) then
183:
184: select psb_attribute_values_s.nextval into
185: l_attribute_value_id from dual;
186:
187: PSB_ATTRIBUTE_VALUES_PVT.INSERT_ROW
188: ( p_api_version => 1.0,
189: p_init_msg_list => null,

Line 974: FROM dual;

970:
971: If (l_default_count = 0) then
972: SELECT psb_entity_s.nextval
973: INTO l_entity_id
974: FROM dual;
975:
976: INSERT INTO psb_entity
977: (entity_id,
978: entity_type,

Line 998: from dual;

994: l_creation_date);
995:
996: Select psb_defaults_s.nextval
997: into l_default_rule_id
998: from dual;
999:
1000: PSB_DEFAULTS_PVT.Insert_Row(
1001: p_api_version => 1.0,
1002: p_init_msg_list => FND_API.G_FALSE,

Line 1088: from dual;

1084: Loop
1085: l_insert_flag := 'Y';
1086: select psb_default_assignments_s.nextval
1087: into l_default_assignment_id
1088: from dual;
1089: l_src_pay_element_id := C_Def_Assign_Rec.pay_element_id;
1090: l_src_pay_option_id := C_Def_Assign_Rec.pay_element_option_id;
1091: l_src_attribute_value_id := C_Def_Assign_Rec.attribute_value_id;
1092: l_src_pay_element_name := null;

Line 1179: from dual;

1175: For C_Def_Distr_Rec in C_Def_Distr
1176: Loop
1177: select psb_default_account_distrs_s.nextval
1178: into l_account_distribution_id
1179: from dual;
1180:
1181: Insert into Psb_default_account_distrs
1182: (account_distribution_id,
1183: default_rule_id,

Line 1254: FROM dual)

1250: l_exec_from_position := l_entity_set_rec.executable_from_position;
1251:
1252: -- generate the sequence for new entity sets
1253: FOR l_new_entity_rec IN (SELECT PSB_ENTITY_SET_S.NEXTVAL entity_set_id
1254: FROM dual)
1255: LOOP
1256: l_new_entity_set_id := l_new_entity_rec.entity_set_id;
1257: END LOOP;
1258: