APPS.PSB_COPY_DATA_EXTRACT_PVT dependencies on PSB_DEFAULT_ASSIGNMENTS

Line 826: from psb_default_assignments

822: attribute_value_id,attribute_value,
823: pay_element_id,pay_element_option_id,
824: element_value,element_value_type,
825: currency_code,pay_basis
826: from psb_default_assignments
827: where default_rule_id = l_src_default_rule_id;
828:
829: Cursor C_Pay_Element is
830: Select name

Line 1086: select psb_default_assignments_s.nextval

1082:
1083: For C_Def_Assign_Rec in C_Def_Assign
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;

Line 1140: PSB_DEFAULT_ASSIGNMENTS_PVT.Insert_Row

1136: l_insert_flag := 'N';
1137: end if;
1138:
1139: if (l_insert_flag = 'Y') then
1140: PSB_DEFAULT_ASSIGNMENTS_PVT.Insert_Row
1141: ( p_api_version => 1.0,
1142: p_init_msg_list => FND_API.G_FALSE,
1143: p_commit => FND_API.G_FALSE,
1144: p_validation_level => FND_API.G_VALID_LEVEL_FULL,